In article <[EMAIL PROTECTED]>, Hassan Schroeder <[EMAIL PROTECTED]> writes:
> 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. A reason could be performance. Storing cent values in an INT field is more efficient. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]