Oracle中NLS_LANG的預設值
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
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 |
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15747463/viewspace-735400/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle nls_lang的設定Oracle
- oracle客戶端NLS_LANG的設定Oracle客戶端
- Python中的預設引數值Python
- oracle增加欄位帶預設值Oracle
- 查詢oracle欄位預設值Oracle
- oracle中spfile的預設位置Oracle
- Recoil 中預設值的正確處理
- 【轉帖】Oracle客戶端NLS_LANG設定Oracle客戶端
- ${VAR:=預設值}和${VAR:-預設值} 區別
- MySQL5.7中的sql_mode預設值MySql
- 為 protocol 中屬性新增預設值Protocol
- Python中如何給字典設定預設值Python
- MYSQL中給時間列設定預設值MySql
- HTML 元素的預設值HTML
- 【譯】GOPATH 的預設值Go
- oracle中的預設帳戶詳解Oracle
- MYSQL中怎樣設列的預設值為Now()的介紹MySql
- 關於配置檔案中的預設值的問題
- JavaScript 中物件解構時指定預設值JavaScript物件
- 淺析Oracle 11g中對資料列預設值變化的優化Oracle優化
- HTML常用元素的預設值HTML
- sqlserver 修改列的預設值SQLServer
- 表列新增預設值的方法
- Oracle9i spfile 中如何用修改系統重置命令將引數值重置為預設值Oracle
- Oracle環境變數NLS_LANGOracle變數
- 設定NLS_LANG引數
- 淺析Oracle 11g中對資料列預設值變化的最佳化Oracle
- oracle時間欄位預設值,hibernate對映Oracle
- 【C++】引數的預設值C++
- css的border屬性預設值CSS
- 查詢oracle中具有預設口令的賬戶Oracle
- antdesign的表單中的下拉框設定預設值BUG處理
- rman會話中設定nls_date_format和nls_lang會話ORM
- Laravel 生成 url,預設值Laravel
- HTTP請求預設值HTTP
- sql設定欄位預設值SQL
- django 設定預設值到SQLDjangoSQL
- oracle 10gR2 如何改變預設au_size值的大小Oracle 10g