Decimals truncated in DOUBLE fields

Bug #298036 reported by jph
2
Affects Status Importance Assigned to Milestone
myodbc (Ubuntu)
New
Undecided
Unassigned

Bug Description

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).

Revision history for this message
jph (jphorst) wrote :

Same problem with a fresh ubuntu jaunty install.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.