Re: LANG and NLS_LANG for UTF8

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 17 Feb 2006 08:07:12 GMT
Message-ID: <1140163631.157450@proxy.dienste.wien.at>

Laurenz Albe <invite_at_spam.to.invalid> wrote:

>>> You have to set NLS_LANG to the character set on the client side.
>>> Usually that means that you should not set this variable at all.
>> 
>> Fail to see this - it will default to what? US7ASCII?

>
> It should default to the codepage that Oracle detects in the operating
> system.

I looked it up in the documentation: I am wrong and you are right, US7ASCII is the default.

I was fooled by the fact that on Windows, OUI makes a registry entry that sets NLS_LANG to the Windows codepage.

Yours,
Laurenz Albe Received on Fri Feb 17 2006 - 02:07:12 CST