Re: Data type for currency

[Paul DuBois]

At 12:08 -0500 9/15/02, Paul DuBois wrote:
>At 8:58 -0700 9/15/02, Todd Cary wrote:
>>With MySQL, should I use Real(8,2) to store information envolving 
>>money/currency?
>
>That'll work.  It'll avoid problems with roundoff error that can
>occur with float/double.

My answer here is incorrect.  I was thinking that REAL is a synonym
for DECIMAL, but that's not right.  REAL is a synonym for DOUBLE,
which will exhibit roundoff problems.

Use DECIMAL, or NUMERIC, which is a synonym.

>
>>
>>Todd
>>--