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