Thanks Balazs and David.. I think that's exactly what I was looking for. I
searched for hours (and I consider myself a fairly decent researcher) and was
just getting frustrated..hah.. I think my problem was I was searching for
money and float problems and such and not monetary. I think
Again.. your forgiveness. This is a MySQL question. If the MySQL mailing lists
would include a [MySQL Help] tag in their subject lines, I'd use them. What I
receive from them is difficult to distinguish from spam half the time so I gave
up.
We had a problem a few months ago and now I can't
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
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