What is the preferred way of storing a dollar amount in the range
0.00 - 999999999.99?

   double
   decimal(11,2)
   bigint  (storing value*100)
   ...?

I'm more interested in speed of use as an indexed column (especially
for range searches) than in disk space usage.

-keith



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

Reply via email to