Decimals truncated in DOUBLE fields

[jph]

Ubuntu 8.04.1 32bit (as well as 8.10)
openoffice.org-base 1:2.4.1-1ubuntu2
libmyodbc 3.51.15r409-2
German localization

I use a mysql database with tables that include fields defined as DOUBLE.
I access this database with OOBase using MYSQL(ODBC).
However, since hardy the decimal places of numbers in DOUBLE fields are cut off (e.g. 82.61 -> 82). Additionally these fields cannot be modified, since the mysql db seems not to accept the data fom OOBAse due to type mismatch.
Error Message: "You have an error in your SQL syntax; check the manual .... for the right syntax to use near '00000000000000000e+00 WHERE 'ID' = 391' at line 1". OOBase lists field as Double [double].

However, with a kubuntu desktop instead of ubuntu (same packages otherwise) decimal places are not truncated and everything works fine. Same behavior with an Intrepid / OpenOffice 3.0.2 installation.

A workaround in ubuntu is to manually install the 5.1.5 odbc driver from the mysql website. This solves the problem with decimals being truncated, but causes some other problems (in forms tables are addressed with tablename only instead of databasename.tablename which causes incompatibilities).

[jph (jphorst)]

Same problem with a fresh ubuntu jaunty install.