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

>
>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