Python, mysql, roundoff problem?
wjdandreta at worldnet.att.net
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