Problem with number field truncating while using oracle 10g odbc driver.

This is a discussion on Problem with number field truncating while using oracle 10g odbc driver. within the Oracle Database forums in category; Hi, I am connecting to Oracle 10g database using oracle odbc 10.2 driver. I have a table defined in the database as follows: Table1(Col1 number,Col2 number(4,3) with values :- (40.83,3.45) (5.04,6.456) (20.4,50.3) My application is running on german locale and my windows setting are also for german and i have set the NLS_LANG properly as GERMANY_GERMAN.WE8MSWIN1252 I am getting the output for select * from Table1 as (40,00,3,45) (5,00,6,456) (20,0,50,3) The number field is getting truncated if no ...

Go Back   Database Forum > Oracle Database

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 05-24-2008, 01:55 AM
Default Problem with number field truncating while using oracle 10g odbc driver.

Hi,

I am connecting to Oracle 10g database using oracle odbc 10.2 driver.
I have a table defined in the database as follows:
Table1(Col1 number,Col2 number(4,3) with values :-
(40.83,3.45)
(5.04,6.456)
(20.4,50.3)

My application is running on german locale and my windows setting are also
for german and i have set the NLS_LANG properly as GERMANY_GERMAN.WE8MSWIN1252
I am getting the output for select * from Table1 as
(40,00,3,45)
(5,00,6,456)
(20,0,50,3)

The number field is getting truncated if no precision and scale is define on
database.

Can anybody help me out why is it happening,is there some problem with
Oracle 10g Odbc Driver with German application?
Am i missing something.i am using de-de as locale,deu-deu as native locale.

Everything is working fine if i do the following:
1. with oracle odbc 9 driver everything is working fine.
2. If application runs on en-us locale.
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 06:53 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.