Re: Best practice column type for storing decimal currency amounts?

[Keith C. Ivey]

On 16 Jul 2003 at 16:02, John Hicks wrote:

> Thanks for the reply, Rudy.
> 
> My source for the statement that decimal values are stored 
> as strings is:
> http://www.mysql.com/doc/en/Numeric_types.html :

DECIMAL values may very well be stored as strings, but presumably 
you're going to do some calculations on them as well at some point, 
and it's likely that not all those calculations are going to occur in 
MySQL (even assuming MySQL handles DECIMAL calculations exactly).  
You may have an easier time in your applications doing the 
calculations on integers.

-- 
Keith C. Ivey <keith@stripped>
Tobacco Documents Online
http://tobaccodocuments.org