NLS Setup for Oracle Clients-Numeric conversion on Win32

From: Stein Andersen <stein.andersen_at_c2i.net>
Date: Mon, 10 May 1999 20:26:01 +0200
Message-ID: <7h78dk$d5m$1@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 - 13:26:01 CDT