I´m having some problems with currency´s fields. Actually I dont know what mysql´s field typeI have to choose..............^ I wanna input this value: U$32.00 but, when I write the query: Select 'field' from table.... it returns.. '32' and not 32.00.
Which select statement do i have to write?
Your requirements are unclear.
Are you saying you want to input the value "U$32.00" and have it come back out as "32.00"?
If that's what you mean, it seems a little odd to me, frankly.
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
