MySQL Lists: mysql: Re: Data type for currency

List:	General Discussion	« Previous Message Next 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!	indiaitmart	15 Sep
• Data type for currency	Todd Cary	15 Sep
• RE: Data type for currency	Dharmendra sawh	15 Sep
• Re: Data type for currency	Joseph Bueno	15 Sep
• Re: Data type for currency	Paul DuBois	15 Sep
• Re: Data type for currency	Paul DuBois	16 Sep
• Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!	Heikki Tuuri	15 Sep
• Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!	Miguel Angel Solórzano	16 Sep
• Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!	indiaitmart	16 Sep
• Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!	Miguel Angel Solórzano	16 Sep
• Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!	Heikki Tuuri	16 Sep
• Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!	indiaitmart	16 Sep
• Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!	indiaitmart	16 Sep
• Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs!	Heikki Tuuri	16 Sep