Re: NLS Setup for Oracle Clients-Numeric conversion on Win32

Hi Stein,
NLS_NUMERIC_CHARACTERS is derived from the territory, in this case AMERICA on the server and NORWAY
on the clients. Obviously you need to set NLS_NUMERIC_CHARACTERS on the server in init<sid>.ora and the registry and/or env vars for sessions on the server also. If you don't specify anything the default behaviour on the client is AMERICAN.AMERICA.WE8ISO8859P1. This will be used when communicating with the database. In most cases setting a non-default language or date format or numeric characters on the server only is not sufficient.

Hth,

Sybrand Bakker, Oracle DBA

Stein Andersen wrote in message <7h78dk$d5m$1_at_romeo.dax.net>...
>Problem have been tested and occurs on oracle 7.2.x and 7.3.x
>
>We have a database which runs NLS_LANGUAGE='AMERICAN.AMERICA.WE8ISO8859P1",
>our clients are running NLS_LANGUAGE="NORWEGIAN_NORWAY.WE8ISO8859P1". As a
>consequense the numeric characters on server
>is '.,' and on clients ',.'.
>
>When converting (implicit or explicit) numerical values stored in a
varchar2
>on server as "nnn.nn", an error
>ORA-1722 occurs. It seems like to_number,sum etc. uses the clients
>characterset to find legal number
>to convert and therefore expects "nnn,nn".
>
>If using "alter sesson set NLS_NUMERIC_CHARACTERS='.,'" or setting it in
>Registry everything functions OK.
>Since we as part of the system also are using Excel and other common
>products, it is necessary to produce
>results according to national windows-standard (for norwegian this is
>nnn,nn).
>
>How do I get the server to use its NLS_LANGUAGE setup for conversion, or
>have I misunderstood something ???
>--
>Yours Sincerly
>Stein Andersen
>E-Privat:stein.andersen_at_c2i.net
>
>
>
Received on Mon May 10 1999 - 14:19:59 CDT