Home » Open Source » Programming Interfaces » Number field getting truncated for german locale via oracle obdc 10g driver (Oacle 10g,Oracle odbc 10,windows xo)
Number field getting truncated for german locale via oracle obdc 10g driver [message #322515] Sat, 24 May 2008 00:24
sumit_goyal
Messages: 2
Registered: May 2008
Junior Member
Hi,

I am connecting to Oracle 10g database using oracle odbc 10g 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.
Previous Topic: connecting to Oracle database using VB .NET
Next Topic: How to load the data into tables
Goto Forum:
  


Current Time: Wed Jul 23 15:44:20 CDT 2014

Total time taken to generate the page: 0.10242 seconds