Space banner This version of the product is in limited support. However, the documentation is available for your convenience. You will not be able to leave comments.

Setting environment variables for language support

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

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

    Language

    Reference

    U.S. English

    Simplified Chinese

    Traditional Chinese

    Japanese

    Korean

  2. Identify the NLS_LANG value that corresponds to the LANG value for your operating system and code page.

  3. 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

Solaris

C

7-bit ASCII

American_America.US7ASCII

Hewlett-Packard HP-UX

C

AIX

C

Windows NT and 2000

not applicablea

Solaris

en_US.UTF-8

UNICODE
UTF-8b

American_America.UTF8

American_America.AL32UTF8

Hewlett-Packard HP-UX

en_US.utf8

AIX

EN_US.utf8

Windows NT and 2000

not applicablea

  • 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

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 applicablea

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

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 applicablea

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

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 applicablea

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

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 applicablea

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


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*