Set Unix, Linux environment NLS_LANG, linuxnls_lang
- Set the NLS_LANG variable
- 1) correctly configure the LC_ALL Parameter
- 2) configure the character set of the telnet/ssh/SecureCRT Client
- In linux, you can use the locale command to view the NLS_LANG settings, as shown in the following example:
- [Root @ HXZG ~] # Locale
- LANG = en_US.UTF-8
- LC_CTYPE = "en_US.UTF-8"
- LC_NUMERIC = "en_US.UTF-8"
- LC_TIME = "en_US.UTF-8"
- LC_COLLATE = "en_US.UTF-8"
- LC_MONETARY = "en_US.UTF-8"
- LC_MESSAGES = "en_US.UTF-8"
- LC_PAPER = "en_US.UTF-8"
- LC_NAME = "en_US.UTF-8"
- LC_ADDRESS = "en_US.UTF-8"
- LC_TELEPHONE = "en_US.UTF-8"
- LC_MEASUREMENT = "en_US.UTF-8"
- LC_IDENTIFICATION = "en_US.UTF-8"
- LC_ALL =
- In most unix versions, "C" is set by default ",
- [Oracle @ HXZG ~] $ Locale
- LANG =
- LC_CTYPE = "C"
- LC_COLLATE = "C"
- LC_MONETARY = "C"
- LC_NUMERIC = "C"
- LC_TIME = "C"
- LC_MESSAGES = "C"
- LC_ALL =
- "C" indicates that NLS_LANG is US7ASCII, which means that your terminal can only display a-z, A-Z and 0-9 characters.
- In Unix environments, you can specify a value through export LC_ALL to set language environment variables.
- [Oracle @ HXZG ~] $ Export LC_ALL = en_US.UTF-8
- [Oracle @ HXZG ~] $ Locale
- LANG = en_US.UTF-8
- LC_CTYPE = "en_US.UTF-8"
- LC_NUMERIC = "en_US.UTF-8"
- LC_TIME = "en_US.UTF-8"
- LC_COLLATE = "en_US.UTF-8"
- LC_MONETARY = "en_US.UTF-8"
- LC_MESSAGES = "en_US.UTF-8"
- LC_PAPER = "en_US.UTF-8"
- LC_NAME = "en_US.UTF-8"
- LC_ADDRESS = "en_US.UTF-8"
- LC_TELEPHONE = "en_US.UTF-8"
- LC_MEASUREMENT = "en_US.UTF-8"
- LC_IDENTIFICATION = "en_US.UTF-8"
- LC_ALL =
- [Oracle @ HXZG ~] $ Export LC_ALL = zh_CN.gb2312
- [Oracle @ HXZG ~] $ Locale
- LANG = en_US.UTF-8
- LC_CTYPE = "zh_CN.gb2312"
- LC_NUMERIC = "zh_CN.gb2312"
- LC_TIME = "zh_CN.gb2312"
- LC_COLLATE = "zh_CN.gb2312"
- LC_MONETARY = "zh_CN.gb2312"
- LC_MESSAGES = "zh_CN.gb2312"
- LC_PAPER = "zh_CN.gb2312"
- LC_NAME = "zh_CN.gb2312"
- LC_ADDRESS = "zh_CN.gb2312"
- LC_TELEPHONE = "zh_CN.gb2312"
- LC_MEASUREMENT = "zh_CN.gb2312"
- LC_IDENTIFICATION = "zh_CN.gb2312"
- LC_ALL = zh_CN.gb2312
- NLS_LANG consists of three parts: NLS_LANG = <NLS_LANGUAGE >_< NLS_TERRITORY>. <clients characterset>
- : NLS_LANG = language _ region _ client Character Set
- When the LANG value is "en_US.UTF-8", it means that NLS_LANG sets NLS_LANG = AMERICAN_AMERICA.AL32UTF8 in the following format
- If the LANG value is "fr_FR.UTF-8", the value set in NLS_LANG is FRENCH_FRANCE.AL32UTF8.
- You can also set LANG through export
- [Oracle @ HXZG ~] $ Export NLS_LANG = AMERICAN_AMERICA.AL32UTF8
- [Oracle @ HXZG ~] $ Locale | grep LANG
- LANG = en_US.UTF-8
- Set the NLS_LANG variable
- 1) correctly configure the LC_ALL Parameter
- 2) configure the character set of the telnet/ssh/SecureCRT Client
- In linux, you can use the locale command to view the NLS_LANG settings, as shown in the following example:
- [Root @ HXZG ~] # Locale
- LANG = en_US.UTF-8
- LC_CTYPE = "en_US.UTF-8"
- LC_NUMERIC = "en_US.UTF-8"
- LC_TIME = "en_US.UTF-8"
- LC_COLLATE = "en_US.UTF-8"
- LC_MONETARY = "en_US.UTF-8"
- LC_MESSAGES = "en_US.UTF-8"
- LC_PAPER = "en_US.UTF-8"
- LC_NAME = "en_US.UTF-8"
- LC_ADDRESS = "en_US.UTF-8"
- LC_TELEPHONE = "en_US.UTF-8"
- LC_MEASUREMENT = "en_US.UTF-8"
- LC_IDENTIFICATION = "en_US.UTF-8"
- LC_ALL =