| ODBC numeric settings [message #439695] |
Tue, 19 January 2010 02:12  |
larsebaer
Messages: 13
Registered: March 2009
|
Junior Member |
|
|
Hi,
I have the following problem:
If I select a row (numeric(15,2) from Table a, i get the following results:
sqldeveloper: 300,67
msaccess via ODBC: 30067
The numericsetting in the DSN is set to "Use Oracle NLS settings"
If I change the setting to "Use US settings" I get identical values. (300,67)
The program we use here creates the DSN new on every start - and the setting is set to the default "Use Oracle NLS settings"
Is there any solution?
Lars
p.s.: client version is 11.1.0.7.20
[Updated on: Tue, 19 January 2010 04:20] Report message to a moderator |
|
|
|
| Re: ODBC numeric settings [message #439786 is a reply to message #439695] |
Tue, 19 January 2010 07:11  |
larsebaer
Messages: 13
Registered: March 2009
|
Junior Member |
|
|
Thank to John (he wrote a reply in the Oracle Community) here is a hint:
-------------------------
Fix
MS Access regional settings need to reflect the same setting of numeric
characters as Oracle NLS setting use.
This functionality have been enhanced in the ODBC releases 9.2.0.2.0, 9.0.1.4.0
and 8.1.7.7.0 or higher.
This is fixed by added the data source configuration option 'Numeric Settings'.
This option is used to choose which numeric settings will be used in receiving
and returning numeric data that is bound as strings. This option allows the
user to choose Oracle NLS settings (the default setting), Microsoft regional
settings (to provide a way to mirror the Oracle ODBC driver's behavior for
greater interoperability) and US numeric settings, which are necessary when
using MS Access or DAO in non-US environments.
cause:
Oracle ODBC Driver use Oracle NLS settings and they could conflict
with MS Access 2000 regional settings which lead to errors like ORA-01722
SQL statements can include numbers represented as numeric or text literals.
Numeric literals are not enclosed in quotes. They are part of the SQL
language syntax and always use a dot as the decimal separator and never
contain a group separator. Text literals are enclosed in single quotes.
They are implicitly or explicitly converted to numbers, if required,
according to the current NLS settings.
-------------------------
Lars
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
