Home » Infrastructure » Windows » ODBC numeric settings (client 11.1.0.7.0 win xp sp3)
ODBC numeric settings [message #439695] Tue, 19 January 2010 02:12 Go to next message
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 Go to previous messageGo to next message
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
Re: ODBC numeric settings [message #439789 is a reply to message #439786] Tue, 19 January 2010 07:18 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Previous Topic: please tell me how to schedule a job for sqlldr?
Next Topic: Freezing Column Heading Using PLSQL
Goto Forum:
  


Current Time: Thu Mar 28 20:44:50 CDT 2024