Python, mysql, roundoff problem?

William Dandreta wjdandreta at worldnet.att.net
Sat Jul 28 09:07:25 EDT 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?

Bill





More information about the Python-list mailing list