Table 4 NLS_LANG Parameter Values for Linux Locales
| Language | Locale ID | NLS_LANG |
|---|---|---|
|
English (American) |
en_US.UTF-8 |
AMERICAN_AMERICA.AL32UTF8 |
|
English (American) |
en_US.ISO-8859-1 |
AMERICAN_AMERICA.WE8ISO8859P1 |
|
English (American) |
en_US.ISO-8859-15 |
AMERICAN_AMERICA.WE8ISO8859P15 |
|
English (Australian) |
en_AU.UTF-8 |
ENGLISH_AUSTRALIA.AL32UTF8 |
|
English (Australian) |
en_AU.ISO-8859-1 |
ENGLISH_AUSTRALIA.WE8ISO8859P1 |
|
English (Australian) |
en_AU.ISO-8859-15 |
ENGLISH_AUSTRALIA.WE8ISO8859P15 |
|
English (British) |
en_GB.UTF-8 |
ENGLISH_UNITED KINGDOM.AL32UTF8 |
|
English (British) |
en_GB.ISO-8859-1 |
ENGLISH_UNITED KINGDOM.WE8ISO8859P1 |
|
English (British) |
en_GB.ISO-8859-15 |
ENGLISH_UNITED KINGDOM.WE8ISO8859P15 |
|
English (Ireland) |
en_IE.UTF-8 |
ENGLISH_IRELAND.AL32UTF8 |
|
English (Ireland) |
en_IE.ISO-8859-1 |
ENGLISH_IRELAND.WE8ISO8859P1 |
|
English (Ireland) |
en_IE.ISO-8859-15 |
ENGLISH_IRELAND.WE8ISO8859P15 |
|
German |
de_DE.UTF-8 |
GERMAN_GERMANY.AL32UTF8 |
|
German |
de_DE.ISO-8859-1 |
GERMAN_GERMANY.WE8ISO8859P1 |
|
German |
de_DE.ISO-8859-15 |
GERMAN_GERMANY.WE8ISO8859P15 |
|
French |
fr_FR.UTF-8 |
FRENCH_FRANCE.AL32UTF8 |
|
French |
fr_FR.ISO-8859-1 |
FRENCH_FRANCE.WE8ISO8859P1 |
|
French |
fr_FR.ISO-8859-15 |
FRENCH_FRANCE.WE8ISO8859P15 |
|
Italian |
it_IT.UTF-8 |
ITALIAN_ITALY.AL32UTF8 |
|
Italian |
it_IT.ISO-8859-1 |
ITALIAN_ITALY.WE8ISO8859P1 |
|
Italian |
it_IT.ISO-8859-15 |
ITALIAN_ITALY.WE8ISO8859P15 |
|
Spanish |
es_ES.UTF-8 |
SPANISH_SPAIN.AL32UTF8 |
|
Spanish |
es_ES.ISO-8859-1 |
SPANISH_SPAIN.WE8ISO8859P1 |
|
Spanish |
es_ES.ISO-8859-15 |
SPANISH_SPAIN.WE8ISO8859P15 |
|
Spanish (Mexico) |
es_MX.UTF-8 |
MEXICAN SPANISH_MEXICO.AL32UTF8 |
|
Spanish (Mexico) |
es_MX.ISO-8859-1 |
MEXICAN SPANISH_MEXICO.WE8ISO8859P1 |
|
Spanish (Mexico) |
es_MX.ISO-8859-15 |
MEXICAN SPANISH_MEXICO.WE8ISO8859P15 |
|
Portuguese (Brazilian) |
pt_BR.UTF-8 |
BRAZILIAN PORTUGUESE_BRAZIL.AL32UTF8 |
|
Portuguese (Brazilian) |
pt_BR.ISO-8859-1 |
BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1 |
|
Portuguese (Brazilian) |
pt_BR.ISO-8859-15 |
BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P15 |
|
Japanese |
ja_JP.EUC-JP |
JAPANESE_JAPAN.JA16EUC |
|
Japanese |
ja_JP.UTF-8 |
JAPANESE_JAPAN.AL32UTF8 |
|
Korean |
ko_KR.EUC-KR |
KOREAN_KOREA.KO16KSC5601 |
|
Korean |
ko_KR.UTF-8 |
KOREAN_KOREA.AL32UTF8 |
|
Chinese (simplified) |
zh_CN.GB18030 |
SIMPLIFIED CHINESE_CHINA.ZHS32GB18030 |
|
Chinese (simplified) |
zh_CN.UTF-8 |
SIMPLIFIED CHINESE_CHINA.AL32UTF8 |
|
Chinese (traditional) |
zh_TW.BIG5 |
TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5 |
|
Chinese (traditional) |
zh_TW.UTF-8 |
TRADITIONAL CHINESE_TAIWAN.AL32UTF8 |
11.3 Supported Character Sets
Table 5 lists the supported character sets in Oracle Database XE. The list is ordered alphabetically in each language group.
The character set AL16UTF16 can be used only as an NCHAR character set, and not as a database character set.
Table 5 Supported Character Sets
| Name | Description |
|---|---|
|
Asian |
|
|
JA16EUC |
EUC 24-bit Japanese |
|
JA16EUCTILDE |
The same as JA16EUC except for the way that the wave dash and the tilde are mapped to and from Unicode |
|
JA16SJIS |
Shift-JIS 16-bit Japanese. The same as JA16SJISTILDE except for the way that the wave dash and the tilde are mapped to and from Unicode |
|
JA16SJISTILDE |
Microsoft Windows Code Page 932 Japanese |
|
KO16KSC5601 |
KSC5601 16-bit Korean |
|
KO16MSWIN949 |
Microsoft Windows Code Page 949 Korean |
|
TH8TISASCII |
Thai Industrial Standard 620-2533 - ASCII 8-bit |
|
VN8MSWIN1258 |
Microsoft Windows Code Page 1258 8-bit Vietnamese |
|
ZHS16CGB231280 |
CGB2312-80 16-bit Simplified Chinese |
|
ZHS16GBK |
GBK 16-bit Simplified Chinese |
|
ZHS32GB18030 |
GB18030-2000 |
|
ZHT16BIG5 |
BIG5 16-bit Traditional Chinese |
|
ZHT16HKSCS |
Microsoft Windows Code Page 950 with Hong Kong Supplementary Character Set HKSCS-2001 (character set conversion to and from Unicode is based on Unicode 3.0) |
|
ZHT16MSWIN950 |
Microsoft Windows Code Page 950 Traditional Chinese |
|
ZHT32EUC |
EUC 32-bit Traditional Chinese |
|
European |
|
|
BLT8CP921 |
Latvian Standard LVS8-92(1) Windows/UNIX 8-bit Baltic |
|
BLT8ISO8859P13 |
ISO 8859-13 Baltic |
|
BLT8MSWIN1257 |
Microsoft Windows Code Page 1257 8-bit Baltic |
|
BLT8PC775 |
IBM-PC Code Page 775 8-bit Baltic |
|
CEL8ISO8859P14 |
ISO 8859-13 Celtic |
|
CL8ISO8859P5 |
ISO 8859-5 Latin/Cyrillic |
|
CL8KOI8R |
RELCOM Internet Standard 8-bit Latin/Cyrillic |
|
CL8KOI8U |
KOI8 Ukrainian Cyrillic |
|
CL8MSWIN1251 |
Microsoft Windows Code Page 1251 8-bit Latin/Cyrillic |
|
EE8ISO8859P2 |
ISO 8859-2 East European |
|
EL8ISO8859P7 |
ISO 8859-7 Latin/Greek |
|
ET8MSWIN923 |
Microsoft Windows Code Page 923 8-bit Estonian |
|
EE8MSWIN1250 |
Microsoft Windows Code Page 1250 8-bit East European |
|
EL8MSWIN1253 |
Microsoft Windows Code Page 1253 8-bit Latin/Greek |
|
EL8PC737 |
IBM-PC Code Page 737 8-bit Greek/Latin |
|
EE8PC852 |
IBM-PC Code Page 852 8-bit East European |
|
LT8MSWIN921 |
Microsoft Windows Code Page 921 8-bit Lithuanian |
|
NE8ISO8859P10 |
ISO 8859-10 North European |
|
NEE8ISO8859P4 |
ISO 8859-4 North and North-East European |
|
RU8PC866 |
IBM-PC Code Page 866 8-bit Latin/Cyrillic |
|
SE8ISO8859P3 |
ISO 8859-3 South European |
|
US7ASCII |
ASCII 7-bit American |
|
US8PC437 |
IBM-PC Code Page 437 8-bit American |
|
WE8ISO8859P1 |
ISO 8859-1 West European |
|
WE8ISO8859P15 |
ISO 8859-15 West European |
|
WE8MSWIN1252 |
Microsoft Windows Code Page 1252 8-bit West European |
|
WE8PC850 |
IBM-PC Code Page 850 8-bit West European |
|
WE8PC858 |
IBM-PC Code Page 858 8-bit West European |
|
Middle Eastern |
|
|
AR8ADOS720 |
Arabic MS-DOS 720 Server 8-bit Latin/Arabic |
|
AR8ASMO8X |
ASMO Extended 708 8-bit Latin/Arabic |
|
AR8ISO8859P6 |
ISO 8859-6 Latin/Arabic |
|
AR8MSWIN1256 |
Microsoft Windows Code Page 1256 8-Bit Latin/Arabic |
|
AZ8ISO8859P9E |
ISO 8859-9 Latin Azerbaijani |
|
IW8ISO8859P8 |
ISO 8859-8 Latin/Hebrew |
|
IW8MSWIN1255 |
Microsoft Windows Code Page 1255 8-bit Latin/Hebrew |
|
TR8MSWIN1254 |
Microsoft Windows Code Page 1254 8-bit Turkish |
|
TR8PC857 |
IBM-PC Code Page 857 8-bit Turkish |
|
WE8ISO8859P9 |
ISO 8859-9 West European & Turkish |
|
Universal |
|
|
AL16UTF16 |
Unicode 4.0 UTF-16 Universal character set |
|
AL32UTF8 |
Unicode 4.0 UTF-8 Universal character set |
|
UTF8 |
Unicode 3.0 UTF-8 Universal character set, CESU-8 compliant |