A Locale Data
This appendix lists the languages, territories, character sets, and other locale data supported by Oracle Database. This appendix contains the following topics:
You can obtain information about character sets, languages, territories, and linguistic sorts by querying the V$NLS_VALID_VALUES
dynamic performance view.
See Also:
Oracle Database Reference for more information about the V$NLS_VALID_VALUES
view
A.1 Languages
Languages in Table A-1 provide support for locale-sensitive information such as:
-
Day and month names and their abbreviations
-
Symbols for equivalent expressions for A.M., P.M., A.D., and B.C.
-
Default sorting sequence for character data when the
ORDER BY
SQL clause is specified -
Writing direction (left to right or right to left)
-
Affirmative and negative response strings (for example,
YES
andNO
)
By using Unicode databases and data types, you can store, process, and retrieve data for almost all contemporary languages, including many that do not appear in Table A-1.
Table A-1 Oracle Database Supported Languages
Language Name | Language Abbreviation | Default Sort |
---|---|---|
ALBANIAN |
sq |
GENERIC_M |
AMERICAN |
us |
binary |
AMHARIC |
am |
GENERIC_M |
ARABIC |
ar |
ARABIC |
ARMENIAN |
hy |
GENERIC_M |
ASSAMESE |
as |
binary |
AZERBAIJANI |
az |
AZERBAIJANI |
BANGLA |
bn |
binary |
BASQUE |
eu |
GENERIC_M |
BELARUSIAN |
be |
RUSSIAN |
BRAZILIAN PORTUGUESE |
ptb |
WEST_EUROPEAN |
BULGARIAN |
bg |
BULGARIAN |
BURMESE |
my |
GENERIC_M |
CANADIAN FRENCH |
frc |
CANADIAN FRENCH |
CATALAN |
ca |
CATALAN |
CROATIAN |
hr |
CROATIAN |
CYRILLIC KAZAKH |
ckk |
GENERIC_M |
CYRILLIC SERBIAN |
csr |
GENERIC_M |
CYRILLIC UZBEK |
cuz |
GENERIC_M |
CZECH |
cs |
CZECH |
DANISH |
dk |
DANISH |
DARI |
prs |
GENERIC_M |
DIVEHI |
dv |
GENERIC_M |
DUTCH |
nl |
DUTCH |
EGYPTIAN |
eg |
ARABIC |
ENGLISH |
gb |
binary |
ESTONIAN |
et |
ESTONIAN |
FINNISH |
sf |
FINNISH |
FRENCH |
f |
FRENCH |
GEORGIAN |
ka |
GENERIC_M |
GERMAN DIN |
din |
GERMAN |
GERMAN |
d |
GERMAN |
GREEK |
el |
GREEK |
GUJARATI |
gu |
binary |
HEBREW |
iw |
HEBREW |
HINDI |
hi |
binary |
HUNGARIAN |
hu |
HUNGARIAN |
ICELANDIC |
is |
ICELANDIC |
INDONESIAN |
in |
INDONESIAN |
IRISH |
ga |
binary |
ITALIAN |
i |
WEST_EUROPEAN |
JAPANESE |
ja |
binary |
KANNADA |
kn |
binary |
KHMER |
km |
GENERIC_M |
KOREAN |
ko |
binary |
KYRGYZ |
ky |
GENERIC_M |
LAO |
lo |
GENERIC_M |
LATIN AMERICAN SPANISH |
esa |
SPANISH |
LATIN BOSNIAN |
lbs |
GENERIC_M |
LATIN SERBIAN |
lsr |
binary |
LATIN UZBEK |
luz |
GENERIC_M |
LATVIAN |
lv |
LATVIAN |
LITHUANIAN |
lt |
LITHUANIAN |
MACEDONIAN |
mk |
binary |
MALAY |
ms |
MALAY |
MALAYALAM |
ml |
binary |
MALTESE |
mt |
GENERIC_M |
MARATHI |
mr |
binary |
MEXICAN SPANISH |
esm |
WEST_EUROPEAN |
NEPALI |
ne |
GENERIC_M |
NORWEGIAN |
n |
NORWEGIAN |
ORIYA |
or |
binary |
PERSIAN |
fa |
GENERIC_M |
POLISH |
pl |
POLISH |
PORTUGUESE |
pt |
WEST_EUROPEAN |
PUNJABI |
pa |
binary |
ROMANIAN |
ro |
ROMANIAN |
RUSSIAN |
ru |
RUSSIAN |
SIMPLIFIED CHINESE |
zhs |
binary |
SINHALA |
si |
GENERIC_M |
SLOVAK |
sk |
SLOVAK |
SLOVENIAN |
sl |
SLOVENIAN |
SPANISH |
e |
SPANISH |
SWAHILI |
sw |
GENERIC_M |
SWEDISH |
s |
SWEDISH |
TAMIL |
ta |
binary |
TELUGU |
te |
binary |
THAI |
th |
THAI_DICTIONARY |
TRADITIONAL CHINESE |
zht |
binary |
TURKISH |
tr |
TURKISH |
TURKMEN |
tk |
GENERIC_M |
UKRAINIAN |
uk |
UKRAINIAN |
URDU |
ur |
GENERIC_M |
VIETNAMESE |
vn |
VIETNAMESE |
A.2 Translated Messages
Oracle Database error messages have been translated into the languages which are listed in Table A-2.
Table A-2 Oracle Database Supported Messages
Name | Abbreviation |
---|---|
ARABIC |
ar |
BRAZILIAN PORTUGUESE |
ptb |
CATALAN |
ca |
CZECH |
cs |
DANISH |
dk |
DUTCH |
nl |
FINNISH |
sf |
FRENCH |
f |
GERMAN |
d |
GREEK |
el |
HEBREW |
iw |
HUNGARIAN |
hu |
ITALIAN |
i |
JAPANESE |
ja |
KOREAN |
ko |
NORWEGIAN |
n |
POLISH |
pl |
PORTUGUESE |
pt |
ROMANIAN |
ro |
RUSSIAN |
ru |
SIMPLIFIED CHINESE |
zhs |
SLOVAK |
sk |
SPANISH |
e |
SWEDISH |
s |
THAI |
th |
TRADITIONAL CHINESE |
zht |
TURKISH |
tr |
A.3 Territories
Table A-3 lists the territories that Oracle Database supports.
Table A-3 Oracle Database Supported Territories
Territory | Territory | Territory |
---|---|---|
AFGHANISTAN |
GEORGIA |
NORWAY |
A.4 Character Sets
The character sets that Oracle Database supports are listed in the following sections according to three broad categories.
In addition, common character set subset/superset combinations are listed. Some character sets can only be used with certain data types. For example, the AL16UTF16 character set can only be used as an NCHAR
character set, and not as a database character set.
Also documented in the comment section are other unique features of the character set that may be important to users or your database administrator. For example, the information includes whether the character set supports the euro currency symbol, whether user-defined characters are supported, and whether the character set is a strict superset of ASCII. (You can use the Database Migration Assistant for Unicode to migrate an existing database to a new character set, only if all of the schema data is a strict subset of the new character set.)
The key for the comment column of the character set tables is:
- SB: single-byte encoding
- MB: multibyte encoding
- FIXED: fixed-width multibyte encoding
- ASCII: strict superset of ASCII
- EURO: euro symbol supported
- UDC: user-defined characters supported
Oracle Database does not document individual code page layouts. For specific details about a particular character set, its character repertoire, and code point values, you can use Oracle Locale Builder. Otherwise, you should refer to the actual national, international, or vendor-specific standards.
A.4.1 Recommended Database Character Sets
Table A-4 lists the recommended and most commonly used ASCII-based Oracle Database character sets. The list is ordered alphabetically within their respective language group.
Table A-4 Recommended ASCII Database Character Sets
Language Group | Character Set | Description | Comments |
---|---|---|---|
Asian |
JA16EUC |
EUC 24-bit Japanese |
MB, ASCII |
Asian |
JA16EUCTILDE |
The same as JA16EUC except for the way that the wave dash and the tilde are mapped to and from Unicode. |
MB, ASCII |
Asian |
JA16SJIS |
Shift-JIS 16-bit Japanese |
MB, ASCII, UDC |
Asian |
JA16SJISTILDE |
The same as JA16SJIS except for the way that the wave dash and the tilde are mapped to and from Unicode. |
MB, ASCII, UDC |
Asian |
KO16MSWIN949 |
MS Windows Code Page 949 Korean |
MB, ASCII, UDC |
Asian |
TH8TISASCII |
Thai Industrial Standard 620-2533 - ASCII 8-bit |
SB, ASCII, EURO |
Asian |
VN8MSWIN1258 |
MS Windows Code Page 1258 8-bit Vietnamese |
SB, ASCII, EURO |
Asian |
ZHS16GBK |
GBK 16-bit Simplified Chinese |
MB, ASCII, UDC |
Asian |
ZHT16HKSCS |
MS 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) |
MB, ASCII, EURO |
Asian |
ZHT16MSWIN950 |
MS Windows Code Page 950 Traditional Chinese |
MB, ASCII, UDC |
Asian |
ZHT32EUC |
EUC 32-bit Traditional Chinese |
MB, ASCII |
European |
BLT8ISO8859P13 |
ISO 8859-13 Baltic |
SB, ASCII |
European |
BLT8MSWIN1257 |
MS Windows Code Page 1257 8-bit Baltic |
SB, ASCII, EURO |
European |
CL8ISO8859P5 |
ISO 8859-5 Latin/Cyrillic |
SB, ASCII |
European |
CL8MSWIN1251 |
MS Windows Code Page 1251 8-bit Latin/Cyrillic |
SB, ASCII, EURO |
European |
EE8ISO8859P2 |
ISO 8859-2 East European |
SB, ASCII |
European |
EL8ISO8859P7 |
ISO 8859-7 Latin/Greek |
SB, ASCII, EURO |
European |
EL8MSWIN1253 |
MS Windows Code Page 1253 8-bit Latin/Greek |
SB, ASCII, EURO |
European |
EE8MSWIN1250 |
MS Windows Code Page 1250 8-bit East European |
SB, ASCII, EURO |
European |
NE8ISO8859P10 |
ISO 8859-10 North European |
SB, ASCII |
European |
NEE8ISO8859P4 |
ISO 8859-4 North and North-East European |
SB, ASCII |
European |
WE8ISO8859P15 |
ISO 8859-15 West European |
SB, ASCII, EURO |
European |
WE8MSWIN1252 |
MS Windows Code Page 1252 8-bit West European |
SB, ASCII, EURO |
Middle Eastern |
AR8ISO8859P6 |
ISO 8859-6 Latin/Arabic |
SB, ASCII |
Middle Eastern |
AR8MSWIN1256 |
MS Windows Code Page 1256 8-Bit Latin/Arabic |
SB, ASCII, EURO |
Middle Eastern |
IW8ISO8859P8 |
ISO 8859-8 Latin/Hebrew |
SB, ASCII |
Middle Eastern |
IW8MSWIN1255 |
MS Windows Code Page 1255 8-bit Latin/Hebrew |
SB, ASCII, EURO |
Middle Eastern |
TR8MSWIN1254 |
MS Windows Code Page 1254 8-bit Turkish |
SB, ASCII, EURO |
Middle Eastern |
WE8ISO8859P9 |
ISO 8859-9 West European & Turkish |
SB, ASCII |
Universal |
AL32UTF8 |
Unicode 12.1 Universal Character Set (UCS), UTF-8 encoding scheme |
MB, ASCII, EURO |
Table A-5 lists the recommended and most commonly used EBCDIC-based Oracle Database character sets. The list is ordered alphabetically within their respective language group.
Table A-5 Recommended EBCDIC Database Character Sets
Language Group | Character Set | Description | Comments |
---|---|---|---|
Asian |
JA16DBCS |
IBM EBCDIC 16-bit Japanese |
MB, UDC |
Asian |
JA16EBCDIC930 |
IBM DBCS Code Page 290 16-bit Japanese |
MB, UDC |
Asian |
KO16DBCS |
IBM EBCDIC 16-bit Korean |
MB, UDC |
Asian |
TH8TISEBCDICS |
Thai Industrial Standard 620-2533-EBCDIC Server 8-bit |
SB |
European |
BLT8EBCDIC1112S |
EBCDIC Code Page 1112 8-bit Server Baltic Multilingual |
SB |
European |
CE8BS2000 |
Siemens EBCDIC.DF.04 8-bit Central European |
SB |
European |
CL8BS2000 |
Siemens EBCDIC.EHC.LC 8-bit Cyrillic |
SB |
European |
CL8EBCDIC1025R |
EBCDIC Code Page 1025 Server 8-bit Cyrillic |
SB |
European |
CL8EBCDIC1158R |
EBCDIC Code Page 1158 Server 8-bit Cyrillic |
SB |
European |
D8EBCDIC1141 |
EBCDIC Code Page 1141 8-bit Austrian German |
SB, EURO |
European |
DK8EBCDIC1142 |
EBCDIC Code Page 1142 8-bit Danish |
SB, EURO |
European |
EE8BS2000 |
Siemens EBCDIC.DF.04 8-bit East European |
SB |
European |
EE8EBCDIC870S |
EBCDIC Code Page 870 Server 8-bit East European |
SB |
European |
EL8EBCDIC423R |
IBM EBCDIC Code Page 423 for RDBMS server-side |
SB |
European |
EL8EBCDIC875R |
EBCDIC Code Page 875 Server 8-bit Greek |
SB |
European |
F8EBCDIC1147 |
EBCDIC Code Page 1147 8-bit French |
SB, EURO |
European |
I8EBCDIC1144 |
EBCDIC Code Page 1144 8-bit Italian |
SB, EURO |
European |
SE8EBCDIC1143 |
EBCDIC Code Page 1143 8-bit Swedish |
SB, EURO |
European |
WE8BS2000 |
Siemens EBCDIC.DF.04 8-bit West European |
SB |
European |
WE8BS2000E |
Siemens EBCDIC.DF.04 8-bit West European |
SB, EURO |
European |
WE8BS2000L5 |
Siemens EBCDIC.DF.L5 8-bit West European/Turkish |
SB |
European |
WE8EBCDIC1047E |
Latin 1/Open Systems 1047 |
SB, EBCDIC, EURO |
European |
WE8EBCDIC1140 |
EBCDIC Code Page 1140 8-bit West European |
SB, EURO |
European |
WE8EBCDIC1145 |
EBCDIC Code Page 1145 8-bit West European |
SB, EURO |
European |
WE8EBCDIC1146 |
EBCDIC Code Page 1146 8-bit West European |
SB, EURO |
European |
WE8EBCDIC1148 |
EBCDIC Code Page 1148 8-bit West European |
SB, EURO |
Middle Eastern |
AR8EBCDIC420S |
EBCDIC Code Page 420 Server 8-bit Latin/Arabic |
SB |
Middle Eastern |
IW8EBCDIC424S |
EBCDIC Code Page 424 Server 8-bit Latin/Hebrew |
SB |
Middle Eastern |
TR8EBCDIC1026S |
EBCDIC Code Page 1026 Server 8-bit Turkish |
SB |
A.4.2 Other Character Sets
Table A-6 lists the other ASCII-based Oracle Database character sets. The list is ordered alphabetically within their language groups.
Table A-6 Other ASCII-based Database Character Sets
Language Group | Character Set | Description | Comments |
---|---|---|---|
Asian |
BN8BSCII |
Bangladesh National Code 8-bit BSCII |
SB, ASCII |
Asian |
IN8ISCII |
Multiple-Script Indian Standard 8-bit Latin/Indian Languages |
SB, ASCII |
Asian |
JA16VMS |
JVMS 16-bit Japanese |
MB, ASCII |
Asian |
KO16KSC5601 |
KSC5601 16-bit Korean |
MB, ASCII |
Asian |
KO16KSCCS |
KSCCS 16-bit (Johab) Korean |
MB, ASCII |
Asian |
TH8MACTHAIS |
Mac Server 8-bit Latin/Thai |
SB, ASCII |
Asian |
VN8VN3 |
VN3 8-bit Vietnamese |
SB, ASCII |
Asian |
ZHS16CGB231280 |
CGB2312-80 16-bit Simplified Chinese |
MB, ASCII |
Asian |
ZHT16BIG5 |
BIG5 16-bit Traditional Chinese |
MB, ASCII |
Asian |
ZHT16CCDC |
HP CCDC 16-bit Traditional Chinese |
MB, ASCII |
Asian |
ZHT16DBT |
Taiwan Taxation 16-bit Traditional Chinese |
MB, ASCII |
Asian |
ZHT16HKSCS31 |
MS Windows Code Page 950 with Hong Kong Supplementary Character Set HKSCS-2001 (character set conversion to and from Unicode is based on Unicode 3.1) |
MB, ASCII, EURO |
Asian |
ZHT32SOPS |
SOPS 32-bit Traditional Chinese |
MB, ASCII |
Asian |
ZHT32TRIS |
TRIS 32-bit Traditional Chinese |
MB, ASCII |
Middle Eastern |
AR8ADOS710 |
Arabic MS-DOS 710 Server 8-bit Latin/Arabic |
SB, ASCII |
Middle Eastern |
AR8ADOS720 |
Arabic MS-DOS 720 Server 8-bit Latin/Arabic |
SB, ASCII |
Middle Eastern |
AR8APTEC715 |
APTEC 715 Server 8-bit Latin/Arabic |
SB, ASCII |
Middle Eastern |
AR8ARABICMACS |
Mac Server 8-bit Latin/Arabic |
SB, ASCII |
Middle Eastern |
AR8ASMO8X |
ASMO Extended 708 8-bit Latin/Arabic |
SB, ASCII |
Middle Eastern |
AR8MUSSAD768 |
Mussa'd Alarabi/2 768 Server 8-bit Latin/Arabic |
SB, ASCII |
Middle Eastern |
AR8NAFITHA711 |
Nafitha Enhanced 711 Server 8-bit Latin/Arabic |
SB, ASCII |
Middle Eastern |
AR8NAFITHA721 |
Nafitha International 721 Server 8-bit Latin/Arabic |
SB, ASCII |
Middle Eastern |
AR8SAKHR706 |
SAKHR 706 Server 8-bit Latin/Arabic |
SB, ASCII |
Middle Eastern |
AR8SAKHR707 |
SAKHR 707 Server 8-bit Latin/Arabic |
SB, ASCII |
Middle Eastern |
AZ8ISO8859P9E |
ISO 8859-9 Latin Azerbaijani |
SB, ASCII |
Middle Eastern |
IN8ISCII |
Multiple-Script Indian Standard 8-bit Latin/Indian Languages |
SB, ASCII |
Middle Eastern |
IW8MACHEBREWS |
Mac Server 8-bit Hebrew |
SB, ASCII |
Middle Eastern |
IW8PC1507 |
IBM-PC Code Page 1507/862 8-bit Latin/Hebrew |
SB, ASCII |
Middle Eastern |
LA8ISO6937 |
ISO 6937 8-bit Coded Character Set for Text Communication |
SB, ASCII |
Middle Eastern |
TR8DEC |
DEC 8-bit Turkish |
SB, ASCII |
Middle Eastern |
TR8MACTURKISHS |
Mac Server 8-bit Turkish |
SB, ASCII |
Middle Eastern |
TR8PC857 |
IBM-PC Code Page 857 8-bit Turkish |
SB, ASCII |
European |
BG8MSWIN |
MS Windows 8-bit Bulgarian Cyrillic |
SB, ASCII |
European |
BG8PC437S |
IBM-PC Code Page 437 8-bit (Bulgarian Modification) |
SB, ASCII |
European |
BLT8CP921 |
Latvian Standard LVS8-92(1) Windows/Unix 8-bit Baltic |
SB, ASCII |
European |
BLT8PC775 |
IBM-PC Code Page 775 8-bit Baltic |
SB, ASCII |
European |
CDN8PC863 |
IBM-PC Code Page 863 8-bit Canadian French |
SB, ASCII |
European |
CEL8ISO8859P14 |
ISO 8859-14 Celtic |
SB, ASCII |
European |
CL8ISOIR111 |
ISOIR111 Cyrillic |
SB, ASCII |
European |
CL8KOI8R |
RELCOM Internet Standard 8-bit Latin/Cyrillic |
SB, ASCII |
European |
CL8KOI8U |
KOI8 Ukrainian Cyrillic |
SB, ASCII |
European |
CL8MACCYRILLICS |
Mac Server 8-bit Latin/Cyrillic |
SB, ASCII |
European |
EE8MACCES |
Mac Server 8-bit Central European |
SB, ASCII |
European |
EE8MACCROATIANS |
Mac Server 8-bit Croatian |
SB, ASCII |
European |
EE8PC852 |
IBM-PC Code Page 852 8-bit East European |
SB, ASCII |
European |
EL8DEC |
DEC 8-bit Latin/Greek |
SB, ASCII |
European |
EL8MACGREEKS |
Mac Server 8-bit Greek |
SB, ASCII |
European |
EL8PC437S |
IBM-PC Code Page 437 8-bit (Greek modification) |
SB, ASCII |
European |
EL8PC851 |
IBM-PC Code Page 851 8-bit Greek/Latin |
SB, ASCII |
European |
EL8PC869 |
IBM-PC Code Page 869 8-bit Greek/Latin |
SB, ASCII |
European |
ET8MSWIN923 |
MS Windows Code Page 923 8-bit Estonian |
SB, ASCII |
European |
HU8ABMOD |
Hungarian 8-bit Special AB Mod |
SB, ASCII |
European |
HU8CWI2 |
Hungarian 8-bit CWI-2 |
SB, ASCII |
European |
IS8PC861 |
IBM-PC Code Page 861 8-bit Icelandic |
SB, ASCII |
European |
LA8ISO6937 |
ISO 6937 8-bit Coded Character Set for Text Communication |
SB, ASCII |
European |
LA8PASSPORT |
German Government Printer 8-bit All-European Latin |
SB, ASCII |
European |
LT8MSWIN921 |
MS Windows Code Page 921 8-bit Lithuanian |
SB, ASCII |
European |
LT8PC772 |
IBM-PC Code Page 772 8-bit Lithuanian (Latin/Cyrillic) |
SB, ASCII |
European |
LT8PC774 |
IBM-PC Code Page 774 8-bit Lithuanian (Latin) |
SB, ASCII |
European |
LV8PC8LR |
Latvian Version IBM-PC Code Page 866 8-bit Latin/Cyrillic |
SB, ASCII |
European |
LV8PC1117 |
IBM-PC Code Page 1117 8-bit Latvian |
SB, ASCII |
European |
LV8RST104090 |
IBM-PC Alternative Code Page 8-bit Latvian (Latin/Cyrillic) |
SB, ASCII |
European |
N8PC865 |
IBM-PC Code Page 865 8-bit Norwegian |
SB, ASCII |
European |
RU8BESTA |
BESTA 8-bit Latin/Cyrillic |
SB, ASCII |
European |
RU8PC855 |
IBM-PC Code Page 855 8-bit Latin/Cyrillic |
SB, ASCII |
European |
RU8PC866 |
IBM-PC Code Page 866 8-bit Latin/Cyrillic |
SB, ASCII |
European |
SE8ISO8859P3 |
ISO 8859-3 South European |
SB, ASCII |
European |
US7ASCII |
ASCII 7-bit American |
SB, ASCII |
European |
US8PC437 |
IBM-PC Code Page 437 8-bit American |
SB, ASCII |
European |
WE8DEC |
DEC 8-bit West European |
SB, ASCII |
European |
WE8DG |
DG 8-bit West European |
SB, ASCII |
European |
WE8ISO8859P1 |
ISO 8859-1 West European |
SB, ASCII |
European |
WE8MACROMAN8S |
Mac Server 8-bit Extended Roman8 West European |
SB, ASCII |
European |
WE8NCR4970 |
NCR 4970 8-bit West European |
SB, ASCII |
European |
WE8NEXTSTEP |
NeXTSTEP PostScript 8-bit West European |
SB, ASCII |
European |
WE8PC850 |
IBM-PC Code Page 850 8-bit West European |
SB, ASCII |
European |
WE8PC858 |
IBM-PC Code Page 858 8-bit West European |
SB, ASCII, EURO |
European |
WE8PC860 |
IBM-PC Code Page 860 8-bit West European |
SB, ASCII |
European |
WE8ROMAN8 |
HP Roman8 8-bit West European |
SB, ASCII |
Universal |
UTF8 |
Unicode 3.0 Universal character set, CESU-8 encoding scheme |
MB, ASCII, EURO |
Table A-7 lists the other EBCDIC-based Oracle Database character sets. The list is ordered alphabetically within their language groups.
Table A-7 Other EBCDIC-based Database Character Sets
Language Group | Character Set | Description | Comments |
---|---|---|---|
Asian |
TH8TISEBCDIC |
Thai Industrial Standard 620-2533 - EBCDIC 8-bit |
SB |
Asian |
ZHS16DBCS |
IBM EBCDIC 16-bit Simplified Chinese |
MB, UDC |
Asian |
ZHT16DBCS |
IBM EBCDIC 16-bit Traditional Chinese |
MB, UDC |
Middle Eastern |
AR8EBCDICX |
EBCDIC XBASIC Server 8-bit Latin/Arabic |
SB |
Middle Eastern |
IW8EBCDIC424 |
EBCDIC Code Page 424 8-bit Latin/Hebrew |
SB |
Middle Eastern |
IW8EBCDIC1086 |
EBCDIC Code Page 1086 8-bit Hebrew |
SB |
Middle Eastern |
TR8EBCDIC1026 |
EBCDIC Code Page 1026 8-bit Turkish |
SB |
Middle Eastern |
WE8EBCDIC37C |
EBCDIC Code Page 37 8-bit Oracle/c |
SB |
European |
BLT8EBCDIC1112 |
EBCDIC Code Page 1112 8-bit Server Baltic Multilingual |
SB |
European |
CL8EBCDIC1025 |
EBCDIC Code Page 1025 8-bit Cyrillic |
SB |
European |
CL8EBCDIC1025C |
EBCDIC Code Page 1025 Client 8-bit Cyrillic |
SB |
European |
CL8EBCDIC1025S |
EBCDIC Code Page 1025 Server 8-bit Cyrillic |
SB |
European |
CL8EBCDIC1025X |
EBCDIC Code Page 1025 (Modified) 8-bit Cyrillic |
SB |
European |
CL8EBCDIC1158 |
EBCDIC Code Page 1158 8-bit Cyrillic |
SB |
European |
D8BS2000 |
Siemens 9750-62 EBCDIC 8-bit German |
SB |
European |
D8EBCDIC273 |
EBCDIC Code Page 273/1 8-bit Austrian German |
SB |
European |
DK8BS2000 |
Siemens 9750-62 EBCDIC 8-bit Danish |
SB |
European |
DK8EBCDIC277 |
EBCDIC Code Page 277/1 8-bit Danish |
SB |
European |
E8BS2000 |
Siemens 9750-62 EBCDIC 8-bit Spanish |
SB |
European |
EE8EBCDIC870 |
EBCDIC Code Page 870 8-bit East European |
SB |
European |
EE8EBCDIC870C |
EBCDIC Code Page 870 Client 8-bit East European |
SB |
European |
EL8EBCDIC875 |
EBCDIC Code Page 875 8-bit Greek |
SB |
European |
EL8GCOS7 |
Bull EBCDIC GCOS7 8-bit Greek |
SB |
European |
F8BS2000 |
Siemens 9750-62 EBCDIC 8-bit French |
SB |
European |
F8EBCDIC297 |
EBCDIC Code Page 297 8-bit French |
SB |
European |
I8EBCDIC280 |
EBCDIC Code Page 280/1 8-bit Italian |
SB |
European |
S8BS2000 |
Siemens 9750-62 EBCDIC 8-bit Swedish |
SB |
European |
S8EBCDIC278 |
EBCDIC Code Page 278/1 8-bit Swedish |
SB |
European |
US8ICL |
ICL EBCDIC 8-bit American |
SB |
European |
US8BS2000 |
Siemens 9750-62 EBCDIC 8-bit American |
SB |
European |
WE8EBCDIC924 |
Latin 9 EBCDIC 924 |
SB, EBCDIC |
European |
WE8EBCDIC37 |
EBCDIC Code Page 37 8-bit West European |
SB |
European |
WE8EBCDIC284 |
EBCDIC Code Page 284 8-bit Latin American/Spanish |
SB |
European |
WE8EBCDIC285 |
EBCDIC Code Page 285 8-bit West European |
SB |
European |
WE8EBCDIC1047 |
EBCDIC Code Page 1047 8-bit West European |
SB |
European |
WE8EBCDIC1140C |
EBCDIC Code Page 1140 8-bit West European |
SB, EURO |
European |
WE8EBCDIC1148C |
EBCDIC Code Page 1148 Client 8-bit West European |
SB, EURO |
European |
WE8EBCDIC500C |
EBCDIC Code Page 500 8-bit Oracle/c |
SB |
European |
WE8EBCDIC500 |
EBCDIC Code Page 500 8-bit West European |
SB |
European |
WE8EBCDIC871 |
EBCDIC Code Page 871 8-bit Icelandic |
SB |
European |
WE8ICL |
ICL EBCDIC 8-bit West European |
SB |
European |
WE8GCOS7 |
Bull EBCDIC GCOS7 8-bit West European |
SB |
Universal |
UTFE |
Unicode 3.0 Universal character set, UTF-EBCDIC encoding scheme |
MB, EURO |
A.4.3 Character Sets that Support the Euro Symbol
Table A-8 lists the character sets that support the Euro symbol.
Table A-8 Character Sets that Support the Euro Symbol
Character Set Name | Hexadecimal Code Value of the Euro Symbol |
---|---|
AL16UTF16 |
20AC |
AL32UTF8 |
E282AC |
AR8MSWIN1256 |
80 |
BLT8MSWIN1257 |
80 |
CL8EBCDIC1158 |
E1 |
CL8EBCDIC1158R |
9F |
CL8MSWIN1251 |
88 |
D8EBCDIC1141 |
9F |
DK8EBCDIC1142 |
5A |
EE8MSWIN1250 |
80 |
EL8EBCDIC423R |
FD |
EL8EBCDIC875R |
DF |
EL8ISO8859P7 |
A4 |
EL8MSWIN1253 |
80 |
F8EBCDIC1147 |
9F |
I8EBCDIC1144 |
9F |
IW8MSWIN1255 |
80 |
KO16KSC5601 |
A2E6 |
KO16KSCCS |
D9E6 |
KO16MSWIN949 |
A2E6 |
SE8EBCDIC1143 |
5A |
TH8TISASCII |
80 |
TR8MSWIN1254 |
80 |
UTF8 |
E282AC |
UTFE |
CA4653 |
VN8MSWIN1258 |
80 |
WE8BS2000E |
9F |
WE8EBCDIC1047E |
9F |
WE8EBCDIC1140 |
9F |
WE8EBCDIC1140C |
9F |
WE8EBCDIC1145 |
9F |
WE8EBCDIC1146 |
9F |
WE8EBCDIC1148 |
9F |
WE8EBCDIC1148C |
9F |
WE8EBCDIC924 |
9F |
WE8ISO8859P15 |
A4 |
WE8MACROMAN8 |
DB |
WE8MACROMAN8S |
DB |
WE8MSWIN1252 |
80 |
WE8PC858 |
DF |
ZHS32GB18030 |
A2E3 |
ZHT16HKSCS |
A3E1 |
ZHT16HKSCS31 |
A3E1 |
ZHT16MSWIN950 |
A3E1 |
A.4.4 Client-Only Character Sets
Table A-9 lists the Oracle Database character sets that are supported as client-only character sets. The list is ordered alphabetically within their respective language groups.
Table A-9 Client-Only Character Sets
Language Group | Character Set | Description | Comments |
---|---|---|---|
Asian |
JA16EUCYEN |
EUC 24-bit Japanese with '\' mapped to the Japanese yen character |
MB |
Asian |
JA16MACSJIS |
Mac client Shift-JIS 16-bit Japanese |
MB |
Asian |
JA16SJISYEN |
Shift-JIS 16-bit Japanese with '\' mapped to the Japanese yen character |
MB, UDC |
Asian |
TH8MACTHAI |
Mac Client 8-bit Latin/Thai |
SB |
Asian |
ZHS16MACCGB231280 |
Mac client CGB2312-80 16-bit Simplified Chinese |
MB |
Asian |
ZHS32GB18030 |
GB18030 32-bit Simplified Chinese |
MB |
European |
CH7DEC |
DEC VT100 7-bit Swiss (German/French) |
SB |
European |
CL8MACCYRILLIC |
Mac Client 8-bit Latin/Cyrillic |
SB |
European |
D7SIEMENS9780X |
Siemens 97801/97808 7-bit German |
SB |
European |
D7DEC |
DEC VT100 7-bit German |
SB |
European |
DK7SIEMENS9780X |
Siemens 97801/97808 7-bit Danish |
SB |
European |
EEC8EUROASCI |
EEC Targon 35 ASCI West European/Greek |
SB |
European |
EEC8EUROPA3 |
EEC EUROPA3 8-bit West European/Greek |
SB |
European |
EE8MACCROATIAN |
Mac Client 8-bit Croatian |
SB |
European |
EE8MACCE |
Mac Client 8-bit Central European |
SB |
European |
EL8PC737 |
IBM-PC Code Page 737 8-bit Greek/Latin |
SB |
European |
EL8MACGREEK |
Mac Client 8-bit Greek |
SB |
European |
E7DEC |
DEC VT100 7-bit Spanish |
SB |
European |
E7SIEMENS9780X |
Siemens 97801/97808 7-bit Spanish |
SB |
European |
F7DEC |
DEC VT100 7-bit French |
SB |
European |
F7SIEMENS9780X |
Siemens 97801/97808 7-bit French |
SB |
European |
I7DEC |
DEC VT100 7-bit Italian |
SB |
European |
I7SIEMENS9780X |
Siemens 97801/97808 7-bit Italian |
SB |
European |
IS8MACICELANDICS |
Mac Server 8-bit Icelandic |
SB |
European |
IS8MACICELANDIC |
Mac Client 8-bit Icelandic |
SB |
European |
NL7DEC |
DEC VT100 7-bit Dutch |
SB |
European |
NDK7DEC |
DEC VT100 7-bit Norwegian/Danish |
SB |
European |
N7SIEMENS9780X |
Siemens 97801/97808 7-bit Norwegian |
SB |
European |
SF7DEC |
DEC VT100 7-bit Finnish |
SB |
European |
S7SIEMENS9780X |
Siemens 97801/97808 7-bit Swedish |
SB |
European |
S7DEC |
DEC VT100 7-bit Swedish |
SB |
European |
SF7ASCII |
ASCII 7-bit Finnish |
SB |
European |
WE8ISOICLUK |
ICL special version ISO8859-1 |
SB |
European |
WE8MACROMAN8 |
Mac Client 8-bit Extended Roman8 West European |
SB |
European |
WE8HP |
HP LaserJet 8-bit West European |
SB |
European |
YUG7ASCII |
ASCII 7-bit Yugoslavian |
SB |
Middle Eastern |
AR8ARABICMAC |
Mac Client 8-bit Latin/Arabic |
SB |
Middle Eastern |
IW7IS960 |
Israeli Standard 960 7-bit Latin/Hebrew |
SB |
Middle Eastern |
IW8MACHEBREW |
Mac Client 8-bit Hebrew |
SB |
Middle Eastern |
TR7DEC |
DEC VT100 7-bit Turkish |
SB |
Middle Eastern |
TR8MACTURKISH |
Mac Client 8-bit Turkish |
SB |
A.4.5 Universal Character Sets
Table A-10 lists the Oracle Database character sets that provide universal language support. They attempt to support all languages of the world, including, but not limited to, Asian, European, and Middle Eastern languages.
Table A-10 Universal Character Sets
Name | Description | Comments |
---|---|---|
AL16UTF16 |
Unicode 12.1 Universal character set, UTF-16BE encoding scheme |
MB, EURO, FIXED |
AL32UTF8 |
Unicode 12.1 Universal character set, UTF-8 encoding scheme |
MB, ASCII, EURO |
UTF8 |
Unicode 3.0 Universal character set, CESU-8 encoding scheme |
MB, ASCII, EURO |
UTFE |
Unicode 3.0 Universal character set, UTF-EBCDIC encoding scheme |
MB, EURO |
Note:
CESU-8 defines an encoding scheme for Unicode that is identical to UTF-8 except for its representation of supplementary characters. In CESU-8, supplementary characters are represented as six-byte sequences that result from the transformation of each UTF-16 surrogate code unit into an eight-bit form that is similar to the UTF-8 transformation, but without first converting the input surrogate pairs to a scalar value.
See Also:
-
Unicode Technical Report #26 “Compatibility Encoding Scheme for UTF-16: 8-Bit (CESU-8)” published on The Unicode Consortium website
A.4.6 Character Set Conversion Support
The following character set encodings are supported for conversion only. They cannot be used as database character set or national character set.
Table A-11 Character Set Encodings Supported for Conversion Only
Character Set Encoding | Description |
---|---|
UTF-16 (little-endian) |
This is a 16-bit little-endian encoding form of Unicode. The corresponding Oracle Database character set is AL16UTF16LE. |
ISO2022-CN |
This encoding covers a variety of Chinese character encodings. They supports both simplified and traditional characters using both GB and CNS/BIG5. Being distinguished by escape sequences and shift characters, these character sets include ASCII, GB 2312-80, CNS 11643-1992 Planes 1 and 2. The corresponding Oracle Database character sets are ZHS16CGB231280, ZHS16GBK and ZHT32TRIS. |
ISO2022-JP |
This encoding is a mixture of ASCII, JIS-Romann, JIS C 6226-1978 and JIS X 0208:1997. It is a subset of Oracle Database character set JA16EUC and can be converted to JA16EUC character set after some calculation. |
ISO2022-KR |
This encoding covers ASCII and KSC 5601 character sets. The corresponding Oracle Database character sets are KO16MSWIN949 and KO16KSC5601. |
HZ-GB-2312 |
This encoding covers GB 2312-80, ASCII and GB-Roman. The corresponding Oracle Database character set is ZHS16CGB231280. |
You can use the Oracle Database character sets related to these encodings as the values for the CONVERT
function parameters source_char_set
and dest_char_set
.
See Also:
-
Oracle Database SQL Language Reference for more information about the
CONVERT
function
A.4.7 Binary Subset-Superset Pairs
Oracle Database does not maintain a list of all subset-superset pairs of its character sets but it does maintain a list of binary subset-superset pairs that it recognizes when checking compatibility of two character sets.
Table A-12 lists all binary subset-superset relationships recognized by Oracle Database.
Table A-12 Binary Subset-Superset Pairs
Subset | Superset |
---|---|
AR8ARABICMACT |
AR8ARABICMAC |
AR8ISO8859P6 |
AR8ASMO8X |
BLT8CP921 |
BLT8ISO8859P13 |
BLT8CP921 |
LT8MSWIN921 |
D7DEC |
D7SIEMENS9780X |
D7SIEMENS9780X |
D7DEC |
DK7SIEMENS9780X |
N7SIEMENS9780X |
I7DEC |
I7SIEMENS9780X |
I7SIEMENS9780X |
IW8EBCDIC424 |
IW8EBCDIC424 |
IW8EBCDIC1086 |
KO16KSC5601 |
KO16MSWIN949 |
LT8MSWIN921 |
BLT8ISO8859P13 |
LT8MSWIN921 |
BLT8CP921 |
N7SIEMENS9780X |
DK7SIEMENS9780X |
US7ASCII |
|
UTF8 |
AL32UTF8 |
WE8DEC |
TR8DEC |
WE8DEC |
WE8NCR4970 |
WE8ISO8859P1 |
WE8MSWIN1252 |
WE8ISO8859P9 |
TR8MSWIN1254 |
WE8NCR4970 |
TR8DEC |
WE8NCR4970 |
WE8DEC |
WE8PC850 |
WE8PC858 |
US7ASCII is a special case because so many other character sets are supersets of it.
Binary Supersets of US7ASCII
The following is a list of all the character sets that are binary supersets of US7ASCII that are recognized by Oracle Database. These character sets are listed in the alphabetical order.
Table A-13 Character Sets That Are Binary Supersets of US7ASCII
Character Set | Character Set | Character Set | Character Set |
---|---|---|---|
AL32UTF8 |
CL8MACCYRILLICS |
JA16VMS |
VN8MSWIN1258 |
See Also:
"Subsets and Supersets" for discussion of what subsets and supersets of a character set are
A.5 Language and Character Set Detection Support
Table A-14 displays the languages and character sets that are supported by the Language and Character Set Detection utility (LCSSCAN
) and the Globalization Development Kit (GDK).
Each language has several character sets that can be detected.
When the binary values for a language match two or more encodings that have a subset/superset relationship, the subset character set is returned. For example, if the language is German and all characters are 7-bit, then US7ASCII is returned instead of WE8MSWIN1252, WE8ISO8859P15, or WE8ISO8859P1.
When the character set is determined to be UTF-8, the Oracle Database character set UTF8 is returned by default unless 4-byte characters (supplementary characters) are detected within the text. If 4-byte characters are detected, then the character set is reported as AL32UTF8.
Table A-14 Languages and Character Sets Supported by LCSSCAN and GDK
Language | Character Sets |
---|---|
Arabic |
AL16UTF16, AL32UTF8, AR8ISO8859P6, AR8MSWIN1256, UTF8 |
Bulgarian |
AL16UTF16, AL32UTF8, CL8ISO8859P5, CL8MSWIN1251, UTF8 |
Catalan |
AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252 |
Croatian |
AL16UTF16, AL32UTF8, EE8ISO8859P2, EE8MSWIN1250, UTF8 |
Czech |
AL16UTF16, AL32UTF8, EE8ISO8859P2, EE8MSWIN1250, UTF8 |
Danish |
AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252 |
Dutch |
AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252 |
English |
AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252 |
Estonian |
AL16UTF16, AL32UTF8, NEE8IOS8859P4, UTF8 |
Finnish |
AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252 |
French |
AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252 |
German |
AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252 |
Greek |
AL16UTF16, AL32UTF8, EL8ISO8859P7, EL8MSWIN1253, UTF8 |
Hebrew |
AL16UTF16, AL32UTF8, IW8ISO8859P8, IW8MSWIN1255, UTF8 |
Hindi |
AL16UTF16, AL32UTF8, IN8ISCII, UTF8 |
Hungarian |
AL16UTF16, AL32UTF8, EE8ISO8859P2, EE8MSWIN1250, UTF8 |
Indonesian |
AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252 |
Italian |
AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252 |
Japanese |
AL16UTF16, AL32UTF8, ISO2022-JP, JA16EUC, JA16SJIS, UTF8 |
Korean |
AL16UTF16, AL32UTF8, ISO2022-KR, KO16KSC5601, KO16MSWIN949, UTF8 |
Latvian |
AL16UTF16, AL32UTF8, NEE8ISO8859P4, UTF8 |
Lithuanian |
AL16UTF16, AL32UTF8, NEE8ISO8859P4, UTF8 |
Malay |
AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252 |
Norwegian |
AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252 |
Persian |
AL16UTF16, AL32UTF8, AR8MSWIN1256, UTF8 |
Polish |
AL16UTF16, AL32UTF8, EE8ISO8859P2, EE8MSWIN1250, UTF8 |
Portuguese |
AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252 |
Romanian |
AL16UTF16, AL32UTF8, EE8ISO8859P2, EE8MSWIN1250, UTF8 |
Russian |
AL16UTF16, AL32UTF8, CL8ISO8859P5, CL8KOI8R, CL8MSWIN1251, RU8PC866, UTF8 |
Serbian |
AL16UTF16, AL32UTF8, CL8ISO8859P5, CL8MSWIN1251, UTF8 |
Simplified Chinese |
AL16UTF16, AL32UTF8, HZ-GB-2312, UTF8, ZHS16GBK, ZHS16CGB231280 |
Slovak |
AL16UTF16, AL32UTF8, EE8ISO8859P2, EE8MSWIN1250, UTF8 |
Slovenian |
AL16UTF16, AL32UTF8, EE8ISO8859P2, EE8MSWIN1250, UTF8 |
Spanish |
AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252 |
Swedish |
AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252 |
Thai |
AL16UTF16, AL32UTF8, TH8TISASCII, UTF8 |
Traditional Chinese |
AL16UTF16, AL32UTF8, UTF8, ZHT16MSWIN950 |
Turkish |
AL16UTF16, AL32UTF8, TR8MSWIN1254, UTF8, WE8ISO8859P9 |
Ukranian |
AL16UTF16, AL32UTF8, CL8ISO8859P5, CL8MSWIN1251, UTF8 |
Vietnamese |
AL16UTF16, AL32UTF8, VN8VN3, UTF8 |
A.6 Linguistic Collations
Oracle Database provides three kinds of linguistic collations, monolingual, multilingual, and UCA.
A monolingual collation is usually created to sort character data in a single language and is named after the corresponding language. Some languages have multiple collations implementing multiple sorting standards for each language. Some monolingual collations have an extended version that handles special linguistic cases. The name of the extended version is prefixed with the letter X
. These special cases typically mean that one character is sorted like a sequence of two characters or a sequence of two characters is sorted as one character. For example, ch
and ll
are treated as a single character in XSPANISH
. Extended monolingual collations may also define special language-specific uppercase and lowercase rules that override standard rules of a character set.
All the linguistic collations can additionally be specified as case-insensitive or accent-insensitive by appending _CI
or _AI
to the linguistic collation name respectively.
Table A-15 lists the monolingual linguistic collations supported by Oracle Database.
See Also:
Table A-1, "Oracle Database Supported Languages" for a list of the default collation for each language
Table A-15 Monolingual Linguistic Collations
Basic Name | Extended Name | Special Cases |
---|---|---|
|
- |
- |
|
- |
- |
|
- |
- |
|
- |
- |
|
- |
- |
|
|
i, I, lowercase i without dot, uppercase I with dot |
|
- |
- |
|
- |
- |
|
- |
- |
|
- |
- |
|
|
æ, AE, ß |
|
|
D, L, N, d, l, n, ß |
|
|
ch, CH, Ch, ß |
|
|
ch, CH, Ch, ß |
|
|
A, ß, Å, å |
|
|
ij, IJ |
|
- |
- |
|
- |
- |
|
- |
- |
|
- |
- |
|
- |
- |
|
|
- |
|
|
ß |
|
|
ß, uppercase ß |
|
|
ß, ä, ö, ü, Ä, Ö, Ü |
|
|
ß, ä, ö, ü, uppercase ß, Ä, Ö, Ü |
|
- |
- |
|
- |
- |
|
- |
- |
|
- |
- |
|
|
cs, gy, ny, sz, ty, zs, ß, CS, Cs, GY, Gy, NY, Ny, SZ, Sz, TY, Ty, ZS, Zs |
|
- |
- |
|
- |
- |
|
- |
- |
|
- |
- |
|
- |
- |
|
- |
- |
|
- |
- |
|
- |
- |
|
- |
- |
|
|
- |
|
- |
- |
|
- |
- |
|
|
dz, DZ, Dz, ß (caron) |
|
|
ß |
|
|
ch, ll, CH, Ch, LL, Ll |
|
- |
- |
|
|
ß |
|
|
æ, AE, ß |
|
- |
- |
|
- |
- |
|
- |
- |
|
|
ß |
Table A-16 lists the multilingual linguistic collations available in Oracle Database. All of them include GENERIC_M
(an ISO standard for sorting Latin-based characters) as a base. Multilingual linguistic collations are used for a specific primary language together with Latin-based characters. For example, KOREAN_M
sorts Korean and Latin-based characters, but it does not sort Chinese, Thai, or Japanese characters.
Table A-16 Multilingual Linguistic Collations
See Also:
Table A-17 illustrates UCA collations.
Table A-17 UCA Collations
Collation Name | UCA Version | Language | Collation Type | Default Setting for Collation Parameters |
---|---|---|---|---|
|
12.1 |
All |
DUCET |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
12.1 |
All (CLDR root) |
standard |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
12.1 |
All (Oracle tailored) |
ORADUCET |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
12.1 |
All (CLDR root, Oracle tailored) |
ORAROOT |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
12.1 |
Canadian French |
standard |
_S4_VS_BYFoot 1_NY_EN_FN_HN_DN_MN |
|
12.1 |
Danish |
standard |
_S4_VS_BN_NY_EN_FUFoot 2_HN_DN_MN |
|
12.1 |
Japanese |
standard |
_S4_VS_BN_NY_EN_FN_HYFoot 3_DN_MN |
|
12.1 |
Korean |
standard |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
12.1 |
Spanish |
standard |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
12.1 |
Spanish |
traditional |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
12.1 |
Thai |
standard |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
12.1 |
Simplified Chinese |
pinyin |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
12.1 |
Simplified Chinese |
radical |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
12.1 |
Simplified Chinese |
stroke |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
12.1 |
Traditional Chinese |
stroke |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
12.1 |
Traditional Chinese |
radical |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
7.0 |
All |
DUCET |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
7.0 |
All |
CLDR root |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
7.0 |
All |
DUCET |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
7.0 |
All |
CLDR root |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
7.0 |
Canadian French |
standard |
_S4_VS_BYFoot 4_NY_EN_FN_HN_DN_MN |
|
7.0 |
Danish |
standard |
_S4_VS_BN_NY_EN_FUFoot 5_HN_DN_MN |
|
7.0 |
Japanese |
standard |
_S4_VS_BN_NY_EN_FN_HYFoot 6_DN_MN |
|
7.0 |
Korean |
standard |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
7.0 |
Spanish |
standard |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
7.0 |
Spanish |
traditional |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
7.0 |
Thai |
standard |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
7.0 |
Simplified Chinese |
pinyin |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
7.0 |
Simplified Chinese |
radical |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
7.0 |
Simplified Chinese |
stroke |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
7.0 |
Traditional Chinese |
stroke |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
7.0 |
Traditional Chinese |
radical |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
6.2 |
All |
DUCET |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
6.2 |
All |
CLDR root |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
6.2 |
Canadian French |
standard |
_S4_VS_BYFoot 7_NY_EN_FN_HN_DN_MN |
|
6.2 |
Danish |
standard |
_S4_VS_BN_NY_EN_FUFoot 8_HN_DN_MN |
|
6.2 |
Japanese |
standard |
_S4_VS_BN_NY_EN_FN_HYFoot 9_DN_MN |
|
6.2 |
Korean |
standard |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
6.2 |
Spanish |
standard |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
6.2 |
Spanish |
traditional |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
6.2 |
Thai |
standard |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
6.2 |
Simplified Chinese |
pinyin |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
6.2 |
Simplified Chinese |
radical |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
6.2 |
Simplified Chinese |
stroke |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
6.2 |
Traditional Chinese |
stroke |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
|
6.2 |
Traditional Chinese |
radical |
_S4_VS_BN_NY_EN_FN_HN_DN_MN |
Footnote 1 Default setting of _BY
is unique for UCA1210_CFRENCH
collation. For all other UCA 12.1 collations, the default setting is _BN
.
Footnote 2 Default setting of _FU
is unique for UCA1210_DANISH
collation. For all other UCA 12.1 collations, the default setting is _FN
.
Footnote 3 Default setting of _HY
is unique for UCA1210_JAPANESE
collation. For all other UCA 12.1 collations, the default setting is _HN
.
Footnote 4 Default setting of _BY
is unique for UCA0700_CFRENCH
collation. For all other UCA 7.0 collations, the default setting is _BN
.
Footnote 5 Default setting of _FU
is unique for UCA0700_DANISH
collation. For all other UCA 7.0 collations, the default setting is _FN
.
Footnote 6 Default setting of _HY
is unique for UCA0700_JAPANESE
collation. For all other UCA 7.0 collations, the default setting is _HN
.
Footnote 7 Default setting of _BY
is unique for UCA0620_CFRENCH
collation. For all other UCA 6.2 collations, the default setting is _BN
.
Footnote 8 Default setting of _FU
is unique for UCA0620_DANISH
collation. For all other UCA 6.2 collations, the default setting is _FN
.
Footnote 9 Default setting of _HY
is unique for UCA0620_JAPANESE
collation. For all other UCA 6.2 collations, the default setting is _HN
.
Note:
Oracle recommends that you do not use UCA 6.2 and 7.0 collations, nor the UCA1210_DUCET
and UCA1210_ROOT
collations. See "Avoiding ORA-12742 Error" for information about the issues affecting these collations.
A.7 Calendar Systems
By default, most territory definitions use the Gregorian calendar system. Table A-18 lists the other calendar systems supported by Oracle Database.
Table A-18 Supported Calendar Systems
Name | Default Date Format | Character Set Used For Default Date Format |
---|---|---|
Japanese Imperial |
EEYYMMDD |
JA16EUC |
ROC Official |
EEyymmdd |
ZHT32EUC |
Thai Buddha |
dd month EE yyyy |
TH8TISASCII |
Persian |
DD Month YYYY |
AR8ASMO8X |
Arabic Hijrah |
DD Month YYYY |
AR8ISO8859P6 |
English Hijrah |
DD Month YYYY |
US7ASCII |
Ethiopian |
Month DD YYYY |
AL32UTF8 |
The Arabic Hijrah and English Hijrah calendars implemented in the Oracle Database are a variant of the tabular Islamic calendar in which the leap years are the 2nd, 5th, 7th, 10th, 13th, 16th, 18th, 21st, 24th, 26th, and 29th in the 30-years cycle and in which the 1st of Muharram 1 AH corresponds to the 16th of July 622 AD. Users can apply deviation days to modify the calendar to suit their requirements, for example, by following an alternative set of leap years. See "Customizing Calendars with the NLS Calendar Utility" for more details about defining deviation days. The only difference between Arabic Hijrah and English Hijrah calendars are month names, which are written, correspondingly, in Arabic and in English transliteration.
The following example shows how July 11, 2019, appears in Japanese Imperial.
A.8 Time Zone Region Names
Table A-19 shows the time zone region names in the time zone files for version 11 that are supplied with the Oracle Database. See Datetime Data Types and Time Zone Support for more information regarding time zone files.
You can see the time zone region names by issuing the following statement:
SELECT DISTINCT(TZNAME) FROM V$TIMEZONE_NAMES;
Table A-19 Time Zone Region Names
Time Zone Name | In the Smaller Time Zone File? | Time Zone Name | In the Smaller Time Zone File? |
---|---|---|---|
Africa/Abidjan |
No |
Asia/Qatar |
No |
Africa/Accra |
No |
Asia/Qyzylorda |
No |
Africa/Addis_Ababa |
No |
Asia/Rangoon |
No |
Africa/Algiers |
No |
Asia/Riyadh |
Yes |
Africa/Asmara |
No |
Asia/Saigon |
No |
Africa/Asmera |
No |
Asia/Sakhalin |
No |
Africa/Bamako |
No |
Asia/Samarkand |
No |
Africa/Bangui |
No |
Asia/Seoul |
Yes |
Africa/Banjul |
No |
Asia/Shanghai |
Yes |
Africa/Bissau |
No |
Asia/Singapore |
Yes |
Africa/Blantyre |
No |
Asia/Taipei |
Yes |
Africa/Brazzaville |
No |
Asia/Tashkent |
No |
Africa/Bujumbura |
No |
Asia/Tbilisi |
No |
Africa/Cairo |
Yes |
Asia/Tehran |
Yes |
Africa/Casablanca |
No |
Asia/Tel_Aviv |
Yes |
Africa/Ceuta |
No |
Asia/Thimbu |
No |
Africa/Conakry |
No |
Asia/Thimphu |
No |
Africa/Dakar |
No |
Asia/Tokyo |
Yes |
Africa/Dar_es_Salaam |
No |
Asia/Ujung_Pandang |
No |
Africa/Djibouti |
No |
Asia/Ulaanbaator |
No |
Africa/Doula |
No |
Asia/Ulan_Bator |
No |
Africa/El_Aaiun |
No |
Asia/Urumqi |
No |
Africa/Freetown |
No |
Asia/Vientiane |
No |
Africa/Gaborone |
No |
Asia/Vladivostok |
No |
Africa/Harare |
No |
Asia/Yakutsk |
No |
Africa/Johannesburg |
No |
Asia/Yetaterinburg |
No |
Africa/Kampala |
No |
Asia/Yerevan |
No |
Africa/Khartoum |
No |
Atlantic/Azores |
No |
Africa/Kigali |
No |
Atlantic/Bermuda |
No |
Africa/Kinshasa |
No |
Atlantic/Canary |
No |
Africa/Lagos |
No |
Atlantic/Cape_Verde |
No |
Africa/Libreville |
No |
Atlantic/Faeroe |
No |
Africa/Lome |
No |
Atlantic/Faroe |
No |
Africa/Luanda |
No |
Atlantic/Jan_Mayen |
No |
Africa/Lubumbashi |
No |
Atlantic/Madeira |
No |
Africa/Lusaka |
No |
Atlantic/Reykjavik |
Yes |
Africa/Malabo |
No |
Atlantic/South_Georgia |
No |
Africa/Maputo |
No |
Atlantic/St_Helena |
No |
Africa/Maseru |
No |
Atlantic/Stanley |
No |
Africa/Mbabane |
No |
Australia/ACT |
Yes |
Africa/Mogadishu |
No |
Australia/Adelaide |
Yes |
Africa/Monrovia |
No |
Australia/Brisbane |
Yes |
Africa/Nairobi |
No |
Australia/Broken_Hill |
Yes |
Africa/Ndjamena |
No |
Australia/Canberra |
Yes |
Africa/Niamey |
No |
Australia/Currie |
No |
Africa/Nouakchott |
No |
Australia/Darwin |
Yes |
Africa/Ouagadougou |
No |
Australia/Eucla |
No |
Africa/Porto-Novo |
No |
Australia/Hobart |
Yes |
Africa/Sao_Tome |
No |
Australia/LHI |
Yes |
Africa/Timbuktu |
No |
Australia/Lindeman |
Yes |
Africa/Tripoli |
Yes |
Australia/Lord_Howe |
Yes |
Africa/Tunis |
No |
Australia/Melbourne |
Yes |
Africa/Windhoek |
No |
Australia/NSW |
Yes |
America/Adak |
Yes |
Australia/North |
Yes |
America/Anchorage |
Yes |
Australia/Perth |
Yes |
America/Anguilla |
No |
Australia/Queensland |
Yes |
America/Antigua |
No |
Australia/South |
Yes |
America/Araguaina |
No |
Australia/Sydney |
Yes |
America/Argentina/Buenos_Aires |
No |
Australia/Tasmania |
Yes |
America/Argentina/Catamarca |
No |
Australia/Victoria |
Yes |
America/Argentina/ComodRivadavia |
No |
Australia/West |
Yes |
America/Argentina/Cordoba |
No |
Australia/Yancowinna |
Yes |
America/Argentina/Jujuy |
No |
Brazil/Acre |
Yes |
America/Argentina/La_Rioja |
Yes |
Brazil/DeNoronha |
Yes |
America/Argentina/Mendoza |
No |
Brazil/East |
Yes |
America/Argentina/Rio_Gallegos |
Yes |
Brazil/West |
Yes |
America/Argentina/Salta |
No |
CET |
Yes |
America/Argentina/San_Juan |
Yes |
CST |
Yes |
America/Argentina/San_Luis |
No |
CST6CDT |
Yes |
America/Argentina/Tucuman |
Yes |
Canada/Atlantic |
Yes |
America/Argentina/Ushuaia |
Yes |
Canada/Central |
Yes |
America/Aruba |
No |
Canada/East-Saskatchewan |
Yes |
America/Asuncion |
No |
Canada/Eastern |
Yes |
America/Atikokan |
No |
Canada/Mountain |
Yes |
America/Atka |
Yes |
Canada/Newfoundland |
Yes |
America/Bahia |
No |
Canada/Pacific |
Yes |
America/Barbados |
No |
Canada/Saskatchewan |
Yes |
America/Belem |
No |
Canada/Yukon |
Yes |
America/Belize |
No |
Chile/Continental |
Yes |
America/Blanc-Sablon |
No |
Chile/EasterIsland |
Yes |
America/Boa_Vista |
No |
Cuba |
Yes |
America/Bogota |
No |
EET |
Yes |
America/Boise |
No |
EST |
Yes |
America/Buenos_Aires |
No |
EST5EDT |
Yes |
America/Cambridge_Bay |
No |
Egypt |
Yes |
America/Campo_Grande |
No |
Eire |
Yes |
America/Cancun |
No |
Etc/GMT |
Yes |
America/Caracas |
No |
Etc/GMT+0 |
Yes |
America/Catamarca |
No |
Etc/GMT+1 |
Yes |
America/Cayenne |
No |
Etc/GMT+10 |
Yes |
America/Cayman |
No |
Etc/GMT+11 |
Yes |
America/Chicago |
Yes |
Etc/GMT+12 |
Yes |
America/Chihuahua |
No |
Etc/GMT+2 |
Yes |
America/Coral_Harbour |
No |
Etc/GMT+3 |
Yes |
America/Cordoba |
No |
Etc/GMT+4 |
Yes |
America/Costa_Rica |
No |
Etc/GMT+5 |
Yes |
America/Cuiaba |
No |
Etc/GMT+6 |
Yes |
America/Curacao |
No |
Etc/GMT+7 |
Yes |
America/Danmarkshavn |
No |
Etc/GMT+8 |
Yes |
America/Dawson |
No |
Etc/GMT+9 |
Yes |
America/Dawson_Creek |
No |
Etc/GMT-0 |
Yes |
America/Denver |
Yes |
Etc/GMT-1 |
Yes |
America/Detroit |
Yes |
Etc/GMT-10 |
Yes |
America/Dominica |
No |
Etc/GMT-11 |
Yes |
America/Edmonton |
Yes |
Etc/GMT-12 |
Yes |
America/Eirunepe |
Yes |
Etc/GMT-13 |
Yes |
America/El_Salvador |
No |
Etc/GMT-14 |
Yes |
America/Ensenada |
Yes |
Etc/GMT-2 |
Yes |
America/Fort_Wayne |
Yes |
Etc/GMT-3 |
Yes |
America/Fortaleza |
No |
Etc/GMT-4 |
Yes |
America/Glace_Bay |
No |
Etc/GMT-5 |
Yes |
America/Godthab |
No |
Etc/GMT-6 |
yes |
America/Goose_Bay |
No |
Etc/GMT-7 |
Yes |
America/Grand_Turk |
No |
Etc/GMT-8 |
Yes |
America/Grenada |
No |
Etc/GMT-9 |
Yes |
America/Guadeloupe |
No |
Etc/GMT0 |
Yes |
America/Guatemala |
No |
Etc/Greenwich |
Yes |
America/Guayaquil |
No |
Europe/Amsterdam |
No |
America/Guyana |
No |
- |
- |
America/Halifax |
Yes |
Europe/Andorra |
No |
America/Havana |
Yes |
Europe/Athens |
No |
America/Hermosillo |
No |
Europe/Belfast |
Yes |
America/Indiana/Indianapolis |
Yes |
Europe/Belgrade |
No |
America/Indiana/Knox |
No |
Europe/Berlin |
No |
America/Indiana/Marengo |
No |
Europe/Bratislava |
No |
America/Indiana/Petersburg |
No |
Europe/Brussels |
No |
America/Indiana/Tell_City |
No |
Europe/Bucharest |
No |
America/Indiana/Vevay |
No |
Europe/Budapest |
No |
America/Indiana/Vincennes |
No |
Europe/Chisinau |
No |
America/Indiana/Winamac |
No |
Europe/Copenhagen |
No |
America/Indianapolis |
Yes |
Europe/Dublin |
Yes |
America/Inuvik |
No |
Europe/Gibraltar |
No |
America/Iqaluit |
No |
Europe/Guernsey |
Yes |
America/Jamaica |
Yes |
Europe/Helsinki |
No |
America/Jujuy |
No |
Europe/Isle_of_Man |
Yes |
America/Juneau |
No |
Europe/Istanbul |
Yes |
America/Kentucky/Louisville |
No |
Europe/Jersey |
Yes |
America/Kentucky/Monticello |
No |
Europe/Kaliningrad |
No |
America/Knox_IN |
No |
Europe/Kiev |
No |
America/La_Paz |
No |
Europe/Lisbon |
Yes |
America/Lima |
No |
Europe/Ljubljana |
No |
America/Los_Angeles |
Yes |
Europe/London |
Yes |
America/Louisville |
No |
Europe/Luxembourg |
No |
America/Maceio |
No |
Europe/Madrid |
No |
America/Managua |
No |
Europe/Malta |
No |
America/Manaus |
Yes |
Europe/Mariehamn |
No |
America/Marigot |
No |
Europe/Minsk |
No |
America/Martinique |
No |
Europe/Monaco |
No |
America/Mazatlan |
Yes |
Europe/Moscow |
Yes |
America/Mendoza |
No |
Europe/Nicosia |
No |
America/Menominee |
No |
Europe/Oslo |
No |
America/Merida |
No |
Europe/Paris |
No |
America/Mexico_City |
Yes |
Europe/Podgorica |
No |
America/Miquelon |
No |
Europe/Prague |
No |
America/Moncton |
No |
Europe/Riga |
No |
America/Monterrey |
Yes |
Europe/Rome |
No |
America/Montevideo |
No |
Europe/Samara |
No |
America/Montreal |
Yes |
Europe/San_Marino |
No |
America/Montserrat |
No |
Europe/Sarajevo |
No |
America/Nassau |
No |
Europe/Simferopol |
No |
America/New_York |
Yes |
Europe/Skopje |
No |
America/Nipigon |
No |
Europe/Sofia |
No |
America/Nome |
No |
Europe/Stockholm |
No |
America/Noronha |
Yes |
Europe/Tallinn |
No |
America/North_Dakota/Center |
No |
Europe/Tirane |
No |
America/North_Dakota/New_Salem |
No |
Europe/Tiraspol |
No |
America/Panama |
No |
Europe/Uzhgorod |
No |
America/Pangnirtung |
No |
Europe/Vaduz |
No |
America/Paramaribo |
No |
Europe/Vatican |
No |
America/Phoenix |
Yes |
Europe/Vienna |
No |
America/Port-au-Prince |
No |
Europe/Vilnius |
No |
America/Port_of_Spain |
No |
Europe/Volgograd |
No |
America/Porto_Acre |
No |
Europe/Warsaw |
Yes |
America/Porto_Velho |
No |
Europe/Zagreb |
No |
America/Port_of_Spain |
No |
Europe/Zaporozhye |
No |
America/Porto_Acre |
No |
Europe/Zurich |
No |
America/Porto_Velho |
No |
GB |
Yes |
America/Puerto_Rico |
No |
GB-Eire |
Yes |
America/Rainy_River |
No |
GMT |
Yes |
America/Rankin_Inlet |
No |
GMT+0 |
Yes |
America/Recife |
No |
GMT-0 |
Yes |
America/Regina |
Yes |
GMT0 |
Yes |
America/Resolute |
No |
Greenwich |
Yes |
America/Rio_Branco |
Yes |
HST |
Yes |
America/Rosario |
No |
Hongkong |
Yes |
America/Santiago |
Yes |
Iceland |
Yes |
America/Santo_Domingo |
No |
Indian/Antananarivo |
No |
America/Sao_Paulo |
Yes |
Indian/Chagos |
No |
America/Scoresbysund |
No |
Indian/Christmas |
No |
America/Shiprock |
Yes |
Indian/Cocos |
No |
America/St_Barthelemy |
No |
Indian/Comoro |
No |
America/St_Johns |
Yes |
Indian/Kerguelen |
No |
America/St_Kitts |
No |
Indian/Mahe |
No |
America/St_Lucia |
No |
Indian/Maldives |
No |
America/St_Thomas |
No |
Indian/Mauritius |
No |
America/St_Vincent |
No |
Indian/Mayotte |
No |
America/Swift_Current |
No |
Indian/Reunion |
No |
America/Tegucigalpa |
No |
Iran |
Yes |
America/Thule |
No |
Israel |
Yes |
America/Thunder_Bay |
No |
Jamaica |
Yes |
America/Tijuana |
Yes |
Japan |
Yes |
America/Tortola |
No |
Kwajalein |
Yes |
America/Vancouver |
Yes |
Libya |
Yes |
America/Virgin |
No |
MET |
Yes |
America/Whitehorse |
Yes |
MST |
Yes |
America/Winnipeg |
Yes |
MST7MDT |
Yes |
America/Yakutat |
No |
Mexico/BajaNorte |
Yes |
America/Yellowknife |
No |
Mexico/BajaSur |
Yes |
Antarctica/Casey |
No |
Mexico/General |
Yes |
Antarctica/Davis |
No |
NZ |
Yes |
Antarctica/DumontDUrville |
No |
NZ-CHAT |
Yes |
Antarctica/Mawson |
No |
Navajo |
Yes |
Antarctica/McMurdo |
No |
PRC |
Yes |
Antarctica/Palmer |
No |
PST |
Yes |
Antarctica/South_Pole |
No |
PST8PDT |
Yes |
Antarctica/Syowa |
No |
Pacific/Apia |
No |
Arctic/Longyearbyen |
No |
Pacific/Auckland |
Yes |
Asia/Aden |
No |
Pacific/Chatham |
Yes |
Asia/Almaty |
No |
Pacific/Easter |
Yes |
Asia/Amman |
No |
Pacific/Efate |
No |
Asia/Anadyr |
No |
Pacific/Enderbury |
No |
Asia/Aqtau |
No |
Pacific/Fakaofo |
No |
Asia/Aqtobe |
No |
Pacific/Fiji |
No |
Asia/Ashgabat |
No |
Pacific/Funafuji |
No |
Asia/Ashkhabad |
No |
Pacific/Galapagos |
No |
Asia/Baghdad |
No |
Pacific/Gambier |
No |
Asia/Bahrain |
No |
Pacific/Guadalcanal |
No |
Asia/Baku |
No |
Pacific/Guam |
No |
Asia/Bangkok |
No |
Pacific/Honolulu |
Yes |
Asia/Beirut |
No |
Pacific/Johnston |
No |
Asia/Bishkek |
No |
Pacific/Kiritimati |
No |
Asia/Brunei |
No |
Pacific/Kosrae |
No |
Asia/Calcutta |
Yes |
Pacific/Kwajalein |
Yes |
Asia/Choibalsan |
No |
Pacific/Majuro |
No |
Asia/Chongqing |
No |
Pacific/Marquesas |
No |
Asia/Chungking |
No |
Pacific/Midway |
No |
Asia/Colombo |
No |
Pacific/Nauru |
No |
Asia/Dacca |
No |
Pacific/Niue |
No |
Asia/Damascus |
No |
Pacific/Norfolk |
No |
Asia/Dhaka |
No |
Pacific/Noumea |
No |
Asia/Dili |
No |
Pacific/Pago_Pago |
Yes |
Asia/Dubai |
No |
Pacific/Palau |
No |
Asia/Dushanbe |
No |
Pacific/Pitcairn |
No |
Asia/Gaza |
No |
Pacific/Ponape |
No |
Asia/Harbin |
No |
Pacific/Rarotonga |
No |
Asia/Ho_Chi_Minh |
No |
Pacific/Rarotonga |
No |
Asia/Hong_Kong |
Yes |
Pacific/Saipan |
No |
Asia/Hovd |
No |
Pacific/Samoa |
Yes |
Asia/Irkutsk |
No |
Pacific/Tahiti |
No |
Asia/Istanbul |
Yes |
Pacific/Tarawa |
No |
Asia/Jakarta |
No |
Pacific/Tongatapu |
No |
Asia/Jayapura |
No |
Pacific/Truk |
No |
Asia/Jerusalem |
Yes |
Pacific/Wake |
No |
Asia/Kabul |
No |
Pacific/Wallis |
No |
Asia/Kamchatka |
No |
Pacific/Yap |
No |
Asia/Karachi |
No |
Poland |
Yes |
Asia/Kashgar |
No |
Portugal |
Yes |
Asia/Kathmandu |
No |
ROC |
Yes |
Asia/Katmandu |
No |
ROK |
Yes |
Asia/Kolkata |
No |
Singapore |
Yes |
Asia/Krasnoyarsk |
No |
Turkey |
Yes |
Asia/Kuala_Lumpur |
No |
US/Alaska |
Yes |
Asia/Kuching |
No |
US/Aleutian |
Yes |
Asia/Kuwait |
No |
US/Arizona |
Yes |
Asia/Macao |
No |
US/Central |
Yes |
Asia/Macau |
No |
US/East-Indiana |
Yes |
Asia/Magadan |
No |
US/Eastern |
Yes |
Asia/Makassar |
No |
US/Hawaii |
Yes |
Asia/Manila |
No |
US/Indiana-Starke |
No |
Asia/Muscat |
No |
US/Michigan |
Yes |
Asia/Nicosia |
No |
US/Mountain |
Yes |
Asia/Novosibirsk |
No |
US/Pacific |
Yes |
Asia/Omsk |
No |
US/Pacific-New |
Yes |
Asia/Oral |
No |
US/Samoa |
Yes |
Asia/Phnom_Penh |
No |
UTC |
No |
Asia/Pontianak |
No |
W-SU |
Yes |
Asia/Pyongyang |
No |
WET |
Yes |
See Also:
A.9 Obsolete Locale Data
This section contains information about obsolete linguistic sorts, character sets, languages, and territories. The obsolete linguistic sort, language, and territory definitions are still available. However, they are supported for backward compatibility only; they may be desupported in a future release. You can obtain a listing of the obsolete character sets, languages, territories, and linguistic sorts for the current database release by querying the V$NLS_VALID_VALUES
view.
A.9.1 Obsolete Linguistic Sorts
Table A-20 contains linguistic sorts that have been obsoleted starting with Oracle Database 10g.
Table A-20 Obsolete Linguistic Sorts
Obsolete Sort Name | Replacement Sort |
---|---|
THAI_TELEPHONE |
THAI_M |
THAI_DICTIONARY |
THAI_M |
CANADIAN FRENCH |
CANADIAN_M |
JAPANESE |
JAPANESE_M |
A.9.2 Obsolete Territories
Table A-21 contains territories that have been obsoleted starting with Oracle Database 10g.
Table A-21 Obsolete Territories
Obsolete Territory Name | Replacement Territory |
---|---|
CIS |
RUSSIA |
MACEDONIA |
FYR MACEDONIA |
YUGOSLAVIA |
BOSNIA AND HERZEGOVINA, SERBIA, or MONTENEGRO |
SERBIA AND MONTENEGRO |
SERBIA or MONTENEGRO |
CZECHOSLOVAKIA |
CZECH REPUBLIC or SLOVAKIA |
A.9.3 Obsolete Languages
Table A-22 contains languages that have been obsoleted starting with Oracle Database 10g.
Table A-22 Obsolete Languages
Obsolete Language Name | Replacement Language |
---|---|
BENGALI |
BANGLA |
A.9.4 Obsolete Character Sets and Replacement Character Sets
Table A-23 lists the obsolete character sets. If you reference any of these character sets in your code, then replace them with the new character set.
Table A-23 Obsolete Character Sets and Their Replacements
Obsolete Character Set | Replacement Character Set |
---|---|
AR8ADOS710T |
AR8ISO8859P6, AR8MSWIN1256, and AL32UTF8 |
AR8ADOS720T |
AR8ISO8859P6, AR8MSWIN1256, and AL32UTF8 |
AR8APTEC715T |
AR8ISO8859P6, AR8MSWIN1256, and AL32UTF8 |
AR8ASMO708PLUS |
AR8ISO8859P6, AR8MSWIN1256, and AL32UTF8 |
AR8HPARABIC8T |
AR8ISO8859P6, AR8MSWIN1256, and AL32UTF8 |
AR8MUSSAD768T |
AR8ISO8859P6, AR8MSWIN1256, and AL32UTF8 |
AR8NAFITHA711T |
AR8ISO8859P6, AR8MSWIN1256, and AL32UTF8 |
AR8NAFITHA721T |
AR8ISO8859P6, AR8MSWIN1256, and AL32UTF8 |
AR8SAKHR707T |
AR8ISO8859P6, AR8MSWIN1256, and AL32UTF8 |
AR8MSAWIN |
AR8MSWIN1256 |
AR8XBASIC |
AR8EBCDIC420S |
CL8EBCDIC875S |
CL8EBCDIC875R |
CL8MSWINDOW31 |
CL8MSWIN1251 |
EL8EBCDIC875S |
EL8EBCDIC875R |
JVMS |
JA16VMS |
JEUC |
JA16EUC |
SJIS |
JA16SJIS |
JDBCS |
JA16DBCS |
KSC5601 |
KO16KSC5601 |
KDBCS |
KO16DBCS |
CGB2312-80 |
ZHS16CGB231280 |
CNS 11643-86 |
ZHT32EUC |
JA16EUCFIXED |
UTF8 and AL16UTF16 See the note following this table |
ZHS32EUCFIXED |
UTF8 and AL16UTF16 |
ZHS16GBKFIXED |
UTF8 and AL16UTF16 |
JA16DBCSFIXED |
UTF8 and AL16UTF16 |
KO16DBCSFIXED |
UTF8 and AL16UTF16 |
ZHS16DBCSFIXED |
UTF8 and AL16UTF16 |
ZHS16CGB231280FIXED |
UTF8 and AL16UTF16 |
ZHT16DBCSFIXED |
UTF8 and AL16UTF16 |
KO16KSC5601FIXED |
UTF8 and AL16UTF16 |
JA16SJISFIXED |
UTF8 and AL16UTF16 See the note following this table |
ZHT16BIG5FIXED |
UTF8 and AL16UTF16 |
ZHT32TRISFIXED |
UTF8 and AL16UTF16 |
Note:
The character sets JA16EUCFIXED
(1830) and JA16SJISFIXED
(1832) are supported on the database client side using:
-
NLS_NCHAR
client environment variable -
ncharset parameter of the
OCIEnvNlsCreate()
call -
OCI_ATTR_CHARSET_ID
attribute of a bind or a define handle
A.9.5 Updates to the Oracle Database Language and Territory Definition Files
Changes have been made to the content in some of the language and territory definition files since Oracle Database 10g. These updates are necessary to correct the legacy definitions that no longer meet the local conventions in some of the languages and territories that Oracle Database supports. These changes include modifications to the currency symbols, month names, and group separators. One example is the local currency symbol for Brazil. This was updated from Cr$
to R$
in Oracle Database 10g.
Please refer to the "Oracle Database Language and Territory Definition Changes" table documented in the $ORACLE_HOME/nls/data/old/data_changes.html
file for a detailed list of the changes.
You should review your existing application code to make sure that the latest locale definition files that are included in this Oracle Database release are being used. If you are not able to make locale-specific code changes to support your applications, then you may use the Oracle9i locale definition files that are included in this Oracle Database release.
To revert back to the Oracle9i language and territory behavior:
-
Shut down the database.
-
Run the script
cr9idata.pl
from the$ORACLE_HOME/nls/data/old
directory. -
Set the
ORA_NLS10
environment variable to the newly created$ORACLE_HOME/nls/data/9idata
directory. -
Restart the database.
Steps 2 and 3 will need to be repeated for all the Oracle Database clients that need to revert back to the Oracle9i definition files.
Note:
Oracle strongly recommends that you use the latest locale definition files included in this Oracle Database release. Oracle9i locale definition files will be desupported in a future release.
A.10 Desupported Locale Data
This section contains information about desupported linguistic sorts and character sets. Oracle will no longer fix bugs related to these features and Oracle can choose to remove the code required to use these features.
A.10.1 Desupported Linguistic Sorts
Table A-24 contains the UCA 6.1 collations that have been desupported starting with Oracle Database 21c. Oracle recommends to migrate schema objects, such as linguistic indexes and data-bound collations created using the UCA 6.1 collations, to the UCA 12.1 collations. UCA 12.1 has incorporated all enhancements and upgrades on UCA since version 6.1. It also has proper weight assignment for all new characters introduced to the Unicode standard since Unicode 6.1.
Table A-24 Desupported UCA 6.1 Collations
Desupported Sort Name | Replacement Sort |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
A.10.2 AL24UTFFSS Character Set Desupported
The Unicode character set AL24UTFFSS was introduced in Oracle Database version 7 to support the UTF-8 encoding scheme and was based on the Unicode standard 1.1. AL24UTFFSS was desupported in Oracle9i. Oracle Database began offering the Unicode database character set UTF8 in Oracle8 and AL32UTF8 in Oracle9i. The AL32UTF8 character set has been updated to conform to Unicode 7.0 in Oracle Database 12c Release 2 (12.2), Unicode 9.0 in Oracle Database 18c and Oracle Database 19c, and Unicode 12.1 in Oracle Database 21c.
The migration path for an existing AL24UTFFSS database is to upgrade to UTF8 prior to upgrading to Oracle Database 9i or later. You can use the Character Set Scanner for data analysis in Oracle8 before attempting to migrate your existing database character set to UTF8.