Re: Currency

[Scott Brown]

I am guessing that you are trying to find a MySQL data type of "Currency", 
which does not exist.

I generally use a column that is DECIMAL(150,2) for US currency.

--Scott



At 01:32 PM 10/2/2003, Fabio Bernardo wrote:
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?

thanks


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]