| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
