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.
bigint should be the most effecient.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
