Scott Purcell wrote:

I am seeking to create a table to hold prices for products. I am
> not sure what type would be best. According to the docs, I have many
> choices, dec, double, float, etc. Can anyone give me an idea, of
> which is the proper choice for handling US currency like so: 1500.99

I can't imagine any reason to use a type other than DECIMAL for a
currency value.

YMMV!
--
Hassan Schroeder ----------------------------- [EMAIL PROTECTED]
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

                          dream.  code.



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



Reply via email to