Re: NLS

From: Valery Yourinsky <vsu_at_softexpress.ru>
Date: 1998/07/02
Message-ID: <BMH1kybp9GA.248@mailserver.corvis.ru>#1/1

karmit_at_my-dejanews.com ÐÉÛÅÔ × ÓÏÏÂÝÅÎÉÉ <6n57i0$qia$1_at_nnrp1.dejanews.com> ...
>Hi,
>
>I have an Oracle7.3 server on Aviion, and client on Portuguese NT.
>The server is defined as AMERICAN_AMERICA.US7ASCII. The client is defined as
>PORTUGUESE_PORTUGAL.WE8ISO8859P1.
>
>Using select userenv('LANGUAGE') from dual on the client, I recived:
>PORTUGUESE_PORTUGAL.US7ASCII. Looking at the NT's registry, I found:
>NLS_LANG=PORTUGUESE_PORTUGAL.WE8ISO8859P1.
>
>1. Why I have a difference between the registry and SQL*Plus?

Because USERENV get CHARACTERSET from server, not from Client!

Valery Yourinsky Received on Thu Jul 02 1998 - 00:00:00 CDT