| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| 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. |
![]() |
| Thread Tools | |
| Display Modes | |