Re: Upgrading Oracle ODBC 10.1.0.2.0
Date: Fri, 4 Jan 2008 05:59:35 -0800 (PST)
On 3 ene, 19:18, "richard.drouill..._at_gmail.com" <richard.drouill..._at_gmail.com> wrote:
> On Dec 31 2007, 9:41 am,valigula<valig..._at_gmail.com> wrote:
> > Upgrading a database from Oracle 9i to 10g.
> > I have encountered a problem with the ODBC 10.1.0.2.0 driver, it
> > transforms the 21 numeric digits from a PK column to a scientific
> > format.
> > Has anyone found this problem?, is any other work around but changing
> > the numer to varchar ?
> > Thanks in advance
> When you encounter the scientific notation, are you using SQL*Plus or
> are you displaying in another program of some kind (like excel)?
> Richard Drouillard
No, no using excel or any other program. What I use is a program that conects to the database using this driver, i mean msqry32 o odbcte32.
I found a workaround to the problem by converting the numerics to char. Also i read something in the driver documentation refering to there is 2 ways of storing the numerics depending on the lenght.
andres Received on Fri Jan 04 2008 - 07:59:35 CST