Re: Storing money values in MySQL
| From: | Balazs Hegedus | Date: | Thu, 19 Jan 2006 23:19:21 +0000 |
| Subject: | Re: Storing money values in MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41082@lists.php.net to get a copy of this message | ||
Hi,
from the MySQL 4.1 manual:
---
The DECIMAL and NUMERIC data types are used to store exact numeric
data values. In MySQL, NUMERIC is implemented as DECIMAL. These types
are used to store values for which it is important to preserve exact
precision, for example with monetary data.
---
and there is lot more there at
http://dev.mysql.com/doc/refman/4.1/en/numeric-types.html
, check it
out, hope it helped.
Balazs