[Zope-DB] total- variables does not work with MySQL 5.x

Lukas Zapletal lukas.zapletal at gmail.com
Thu Aug 30 03:08:07 EDT 2007


I have a problem with "total-*" variables when suming results from
MySQL 5.x. It does not work with monetary (float) numbers - only with
integers. When trying to sum floats it cointanins nulls. IMHO the
reason is in a driver because it probably do not convert numbers in
national currency format (some countries, e.g. mine, do not use dot as
separator). The problem is that the driver is outdated and old.

Is there a fixaround? How could I for example convert the numbers
explicitely? Or how do I ovverride the behaviour of the code that is
responsible for the sumarizing?



Lukas Zapletal

More information about the Zope-DB mailing list