Re: NLS parameters & Windows Regional settings

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/19
Message-ID: <958742141.20817.0.pluto.d4ee154e@news.demon.nl>#1/1

Assuming you don't change them often, IMO it should be sufficient to set the appropiate values in the registry under HKLM\software\oracle. In your case those you should have

NLS_LANG = "France_French.WE8ISO8859P1"
NLS_LANGUAGE="French"
NLS_TERRITORY="France"

parameters like

NLS_DATE_LANGUAGE, NLS_DATE_FORMAT, NLS_NUMERIC_CHARACTERS *all* derive from
NLS_TERRITORY
NLS_SORT derives from NLS_LANGUAGE

Just experiment and query nls_session_parameters, and you will see how this works.

Hth,

Sybrand Bakker, Oracle DBA

sofresud <sofresud_at_wanadoo.fr> schreef in berichtnieuws 8g3543$rt7$1_at_wanadoo.fr...
>
> Hi,
>
>
> Is there a way to have the same NLS_PARAMETERS in a ORA SESSION (mainly
> nls_numeric_characters) and the regions parameters in the control panel of
> Windows ??
>
> I can execute a kind of "ALTER SESSION SET NLS_*********=mysettings" just
> after the connection but my problem is to know what my settings should be
> according to the windows setting
>
> if the settings between Oracle and Windows are not the same ... i got a
> "type mismatch error" while trying to read or fetch numerical values.
>
> Thanks for your help
>
> Stephan.
>
>
>
Received on Fri May 19 2000 - 00:00:00 CDT