http://bugs.winehq.org/show_bug.cgi?id=12042
--- Comment #3 from Jerry Park park.jerry@gmail.com 2008-03-15 15:09:43 --- (In reply to comment #0)
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.
(In reply to comment #2)
just to be clear, you're using the windows version of Firebird on Linux?
We are using both the Linux version of Firebird and the Windows version running under Wine, and both behave the same way. Both connect to our application (called SynapseDirect, programmed in REBOL) via the Firebird Native Windows ODBC driver running under Wine, so the problem we are describing is with how Wine handles Native Windows ODBC.