Re: Storing money values in MySQL
| From: | Balazs Hegedus | Date: | Thu, 19 Jan 2006 23:36:14 +0000 |
| Subject: | Re: Storing money values in MySQL | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41083@lists.php.net to get a copy of this message | ||
Me again,
Sorry for the rtfm stuff, I googled around and found this:
http://bugs.mysql.com/bug.php?id=10719
and another thing, maybe worth a try; MySQL stores decimal numbers as
strings...did you try to input decimals as string? I mean not:
UPDATE SomeTable SET AmtOwed = 10.74
but:
UPDATE SomeTable SET AmtOwed = '10.74'
Bye,
Balazs