Set NLS_LANG in Unix,Linux environment
Setting NLS_LANG under UNIX environment How to set NLS_LANG variable 1) Configure LC_ALL parameter correctly 2) Configure telnet/ssh/SecureCRT client character set In linux, you can use locale command to view NLS_LANG setting. As shown in the following example [root@HXZG ~]# localelANG="en_US.UTF-8LC_CTYPE="en_US.UTF-8"LC_NUMERIC="en_US.UTF-8"LC_TIME="en_US.UTF-8 "LC_COLATE ="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= Most unix versions have the following default setting "C,"[oracle@HXZG ~]$ localelANG=LC_CTYPE="C"LC_COLATE ="C" LC_MONETARY="C" LC_NUMERIC="C"LC_TIME="C"LC_MESSAGES="C"LC_ALL="C" means NLS_LANG is US7ASCII, which means your terminal can only display a-z, ASCII A-Z and 0-9 These characters can be set in Unix environments by specifying a value via export LC_ALL to set the language environment variable [oracle@HXZG ~]$ export LC_ALL=en_US. UTF-8 [oracle@HXZG ~]$ localelANG=en_US. UTF-8LC_CTYPE ="en_US. UTF-8"LC_NUMERIC="en_US. UTF-8"LC_COLATE ="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 ~]$ localeLANG=en_US.UTF-8LC_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.gb2312NLS_LANG is grouped into three parts: NLS_LANG=_. :NLS_LANG= Language_Region_Client Character Set When the LANG value is "en_US. UTF-8", it means that NLS_LANG is set in the following format NLS_LANG= AMERICAN_AMERICAN. AL32UTF8 If the LANG value is "fr_FR. UTF-8", the value set in NLS_LANG is FRENCH_FRANCE.AL32UTF8. You can also set LANG[oracle@HXZG ~]$ export NLS_LANG= AMERICAN_AMERICAN. AL32UTF8 [oracle@HXZG ~]$ locale by exporting| grep LANGLANG=en_US.UTF-8
