http://bugs.winehq.org/show_bug.cgi?id=12042
Summary: Native Windows ODBC:Firebird stores numbers in sientific notation using datatype decimal Product: Wine Version: 0.9.56. Platform: PC OS/Version: Linux Status: UNCONFIRMED Severity: normal Priority: P2 Component: msvcrt AssignedTo: wine-bugs@winehq.org ReportedBy: park.jerry@gmail.com
The following applications and scripts were used on ubuntu 7.04 and Puppy Linux 3.0.1 with the same results.
Firebird-2.0.1.12855-1 RDBMS Firebird 2.0.0 ODBC driver winetricks script from Dan Kegel mdac2.5 or mdac2.8 per winetricks Several versions of Wine, including 0.9.55 and 0.9.56
Using decimal datatype with Firebird on WindowsXP and Win2003 server records whole and decimal numbers correctly in the Firebird RBDMS.
On ubuntu and Puppy Linux with either Linux Firebird or Windows Firebird running under Wine 0.9.56 and either mdac 2.5 or mdac 2.8, whole or decimal numbers are stored in scientific notation and lose the power.
We were able to work around this problem by using datatype float rather than decimal, but some may not be able to change their database schema.