Re: NLS_LANG (General Questions)

Terry Heung-Man Lam <tlam_at_cs.umd.edu> kirjoitti artikkelissa
>
> Hi gurus,
>
> I have some general questions regarding to NLS_LANG, hope you
> can give me some help:
>
> 1. if environment variable NLS_LANG is not set, what is the default
value?

I quess it is AMERICAN_AMERICA.US7ASCII. At least the charset portion is US7ASCII by default.

>
> 2. How to determine the NLS_LANG value of a database instance (including
> language, territory, and character set)?

There is no NLS_LANG in database. You specify the characterset of the database when creating it (use 8-bit charset). You can set other NLS-parameters in init.ora. See the values with the following command in svrmgrl:

        SVRMGR> show parameters NLS

> 3. What is common setting for NLS_LANG for Oracle databases in US?

Again, no NLS_LANG parameter in database. When you create a new database set the CHARACTERSET to some 8-bit charset (WE8DEC for instance). Set the NLS_LANG environment variable correctly on every client, at least the charset portion. This depends on the client, for instance on VT220 terminal it may be WE8DEC, on HP-terminal WE8HP and on Win95/WinNT WE8ISO8859P1 The incorrect setting causes troubles to handle multinational characters, like Ä,Ö,Å (scandinavian chars).

>
> Thanks a lot!
> Terry
>

HTH,
Timo Haatainen Received on Wed Apr 01 1998 - 00:00:00 CST