[egenix-users] Egenix - Zope / MySQL - floats losing 'behind point' info

[Robert-Reinder Nederhoed]

Good day,


When I perform from Z SQL (see attached image):
   select 0.1

The result is:
   0.0

Setup:
   Zope 2.9
   Python 2.3.5
   mxODBCZopeDA 1.0.10
   MySQL 4.1.13

This does not happen when we query our DB2 database.

Anyone a suggestion on the cause of and cure for this phenomenon?


Friendly greetings, Robert-Reinder

The Hague, Netherlands

--
-------------- next part --------------
A non-text attachment was scrubbed...
Name: select_float_error.png
Type: image/png
Size: 7461 bytes
Desc: not available
Url : /mailman-archives/egenix-users/attachments/20070207/4ac719ca/select_float_error.png