Re: NLS_LANG SETTING IN THE REGISTRY (ORA-12705)

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 25 Aug 2004 18:47:21 +0200
Message-ID: <412cc226$0$14155$636a15ce@news.free.fr>

"Fran?ois Bourdages" <francois.bourdages_at_harfan.com> a écrit dans le message de news:92e05f1e.0408250752.688cdc79_at_posting.google.com...
> HI,
> We have two databases :
> db1 : oracle entreprise 8.1.7.4 on windows 2000
> characterset : we8so8859p1
>
> db2 : oracle entreprise 9.2.0.4 on windows 2000
> characterset : we8mswin1252
>
> and lets say : one client
> Client config : oracle 8.1.7
> nsl_lang in the registry : CANADIAN FRENCH_CANADA.WE8ISO8859P1
>
> When the "client" try to connect to db1 : OK
> When the "client" try to connect to db1 : not working. (see below)
>

<snip>

In 9iR2, it works if there is no space between CANADIAN and FRENCH even if v$nls_valid_value says there is a space. (time to a TAR :( ) In 8i, if you omit the space you fail.

-- 
Regards
Michel Cadot

Received on Wed Aug 25 2004 - 11:47:21 CDT