NLS LANG
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
NLS_LANG is an environment variable used to define language, territory and character set properties.
Setting NLS_LANG
Windows (in cmd window):
set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
Unix/ Linux:
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
Valid settings
Here are some valid NLS_LANG settings:
- French_France.WE8ISO8895P1
- French_Switzerland.WE8ISO8895P1
- Norwegian_Norway.NDK7DEC
- Norwegian_Norway.WE8ISO8895P1
- Japanese_Japan.JA16SJIS
- Arabic_Egypt.AR8MSWIN1256
- American_America.AR8MSWIN1256
- American_America.WE8ISO8859P1
- Latvian_Latvia.BLT8CP921
The space in some country names must be there:
- DUTCH_THE NETHERLANDS.WE8ISO8859P15
- CZECH_CZECH REPUBLIC.EE8MSWIN1250
Also see
- NLS - National Language Support
- Other environment variables: ORACLE_HOME and ORACLE_SID
