Python, mysql, roundoff problem?

[Greg Jorgensen]

"William Dandreta" <wjdandreta at worldnet.att.net> wrote:

> mysql stores numbers as strings. I discovered that when converted to
floats
> in Python they are not exactly the same which can cause roundoff errors.
The
> floats represent money and I need to be sure there is no roundoff errors.
>
> What is normally done to deal with this situation?

Work with pennies instead of dollars. Store 12949 instead of 129.49. Do
integer arithmetic with pennies rather than floating-point arithmetic with
dollars. Divide by 100 when you need to display the value.

Greg Jorgensen
PDXperts LLC
Portland, Oregon, USA