Re: Storing money values in MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 that's the keyword that would have done it for me.

I appreciate the help guys!  Best of luck to both of you (and anyone else I inadvertantly missed who may have responded).

-TG

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


___________________________________________________________
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux