Oracle中NLS_LANG的默认值

谷2173

　　

Table 4 NLS_LANG Parameter Values for Linux Locales LanguageLocale IDNLS_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
NameDescriptionAsian
 
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