Python, mysql, roundoff problem?

William Dandreta wjdandreta at
Sat Jul 28 15:07:25 CEST 2001

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?

I am considering using mysql 64 bit integers to eliminate any roundoff
errors. What kind of performance problems might his cause?


More information about the Python-list mailing list