List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 16 2002 5:57pm
Subject:Re: Data type for currency
View as plain text  
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
>>--

Thread
mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!indiaitmart15 Sep
  • Data type for currencyTodd Cary15 Sep
    • RE: Data type for currencyDharmendra sawh15 Sep
      • Re: Data type for currencyJoseph Bueno15 Sep
    • Re: Data type for currencyPaul DuBois15 Sep
      • Re: Data type for currencyPaul DuBois16 Sep
Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!Heikki Tuuri15 Sep
  • Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!Miguel Angel Sol√≥rzano16 Sep
Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!indiaitmart16 Sep
  • Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!Miguel Angel Sol√≥rzano16 Sep
Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!Heikki Tuuri16 Sep
Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!indiaitmart16 Sep
Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!indiaitmart16 Sep
Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!Heikki Tuuri16 Sep