[Bug 12042] New: Native Windows ODBC: Firebird stores numbers in sientific notation using datatype decimal
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.
http://bugs.winehq.org/show_bug.cgi?id=12042
Jerry Park park.jerry@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |park.jerry@gmail.com
http://bugs.winehq.org/show_bug.cgi?id=12042
James Hawkins truiken@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- CC|park.jerry@gmail.com |
--- Comment #1 from James Hawkins truiken@gmail.com 2008-03-15 03:34:19 --- You are the reporter, you are already cc'ed.
http://bugs.winehq.org/show_bug.cgi?id=12042
Lei Zhang thestig@google.com changed:
What |Removed |Added ---------------------------------------------------------------------------- URL| |http://www.firebirdsql.org/ Keywords| |download Summary|Native Windows ODBC:Firebird|Native Windows ODBC:Firebird |stores numbers in sientific |stores numbers in scientific |notation using datatype |notation using datatype |decimal |decimal
--- Comment #2 from Lei Zhang thestig@google.com 2008-03-15 11:01:00 --- just to be clear, you're using the windows version of Firebird on Linux?
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.
http://bugs.winehq.org/show_bug.cgi?id=12042
--- Comment #4 from Austin English austinenglish@gmail.com 2008-12-18 12:09:15 --- Please retest in 1.1.10.
http://bugs.winehq.org/show_bug.cgi?id=12042
Austin English austinenglish@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution| |ABANDONED
--- Comment #5 from Austin English austinenglish@gmail.com 2010-06-27 18:47:49 --- No response in a year and half, and it's unclear how to reproduce this bug. Marking abandoned.
http://bugs.winehq.org/show_bug.cgi?id=12042
Austin English austinenglish@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED
--- Comment #6 from Austin English austinenglish@gmail.com 2010-06-27 18:47:56 --- Closing.
-
wine-bugs＠winehq.org