Setting environment variables for language support

To run BMC SQL-BackTrack using one of the non-English locales, perform the following steps:

Check the LANG environment variable for your operating system and code page in the following tables.

Language	Reference
U.S. English	LANG and NLS_LANG values for U.S. English
Simplified Chinese	LANG and NLS_LANG values for Simplified Chinese
Traditional Chinese	LANG and NLS_LANG values for Traditional Chinese
Japanese	LANG and NLS_LANG values for Japanese
Korean	LANG and NLS_LANG values for Korean

Identify the NLS_LANG value that corresponds to the LANG value for your operating system and code page.
If the value of your NLS_LANG environment variable does not match the value that you identified in step 2, change your NLS_LANG environment variable to that value.
Warning
Both variables must use the correct values. If the LANG and NLS_LANG values do not correspond, BMC SQL-BackTrack backup and recovery operations could fail.
Use the same LANG value during both backup and recovery.

LANG and NLS_LANG values for U.S. English

Operating system LANG		Code page name	Oracle NLS_LANG value
Platform	Value	Code page name	Oracle NLS_LANG value
Solaris	C	7-bit ASCII	American_America.US7ASCII
Hewlett-Packard HP-UX	C
AIX	C
Windows NT and 2000	not applicable^a
Solaris	en_US.UTF-8	UNICODE UTF-8^b	American_America.UTF8 American_America.AL32UTF8
Hewlett-Packard HP-UX	en_US.utf8
AIX	EN_US.utf8
Windows NT and 2000	not applicable^a

^_a Windows does not have a LANG environment variable. From the Control Panel, access Regional Settings or Regional Options, and set the operating system to English (United States).
^b Starting with version 4.0, BMC SQL-BackTrack supports the Unicode UTF-8 encoding scheme for U.S. English only.

LANG and NLS_LANG values for Simplified Chinese

Operating system LANG		Code page name	Oracle NLS_LANG value
Platform	Value	Code page name	Oracle NLS_LANG value
Solaris	zh zh_CN.EUC chinese zh_CN.gb	Chinese GBK	Simplified Chinese_ China.ZHS16GBK or American_America.ZHS16GBK
Hewlett-Packard HP-UX	zh_CN.hp15CN zh_CN.gb
AIX	zh_CN Zh_CN zh_CN.gb Zh_CN.GBK zh_CN.IBM-eucCN
Windows NT and 2000	not applicable^a	CP936

^a Windows does not have a LANG environment variable. From the Control Panel, access Regional Settings or Regional Options, and set the operating system to Chinese (PRC).

LANG and NLS_LANG values for Traditional Chinese

Operating system LANG		Code page name	Oracle NLS_LANG value
Platform	Value	Code page name	Oracle NLS_LANG value
Solaris	zh_TW.big5 zh_TW.BIG5	Big 5	Traditional Chinese_Taiwan.ZHT16BIG5 or American_America.ZHT16BIG5
Hewlett-Packard HP-UX	zh_TW.big5
AIX	Zh_TW.big5
Solaris	zh_TW zh_TW.eucTW tchinese zh_TW.EUC	Extended UNIX Code (EUC)	Traditional Chinese_Taiwan.ZHT32EUC or American_America.ZHT32EUC
Hewlett-Packard HP-UX	zh_TW.eucTW
AIX	zh_TW.IBM-eucTW zh_TW zh_TW.eucTW
Windows NT and 2000	not applicable^a	CP950	Traditional Chinese_ Taiwan.ZHT16MSWIN950 or American_ America.ZHT16MSWIN950

^a Windows does not have a LANG environment variable. From the Control Panel, access Regional Settings or Regional Options, and set the operating system to Chinese (Taiwan).

LANG and NLS_LANG values for Japanese

Operating system LANG		Code page name	Oracle NLS_LANG value
Platform	Value	Code page name	Oracle NLS_LANG value
Solaris	ja_JP.PCK	Japanese SJIS	Japanese_Japan.JA16SJIS or American_America.JA16SJIS
Hewlett-Packard HP-UX	ja_JP.SJIS japanese
AIX	japanese ja_JP
Solaris	ja ja_JP ja_JP.eucJP japanese	Extended UNIX Code (EUC)	Japanese_Japan.JA16EUC or American_America.JA16EUC
Hewlett-Packard HP-UX	ja_JP.eucJP
AIX	ja_JP ja_JP.IBM-eucJP
Windows NT and 2000	not applicable^a	CP932	Japanese_Japan.JA16SJIS or American_America.JA16SJIS

^a Windows does not have a LANG environment variable. From the Control Panel, access Regional Settings or Regional Options, and set the operating system to Japanese.

LANG and NLS_LANG values for Korean

Operating system LANG		Code page name	Oracle NLS_LANG value
Platform	Value	Code page name	Oracle NLS_LANG value
Solaris	ko korean ko_KR.EUC	Extended UNIX Code (EUC)	Korean_Korea.KO16KSC6501 or American_America.KO16KSC6501
Hewlett-Packard HP-UX	ko_KR.eucKR
AIX	ko_KR ko_KR.IBM-eucKR
Windows NT and 2000	not applicable^a	CP949	Korean_Korea.KO16MSWIN949 or American_America.KO16MSWIN949

^a Windows does not have a LANG environment variable. From the Control Panel, access Regional Settings or Regional Options, and set the operating system to Korean.

Language-support-features

Setting environment variables for language support

On this page