数据库

img llmmysun

Listing of Character Sets FOR 9.2, 9.0.1 and 8.1.7 including Language references

发表于2004/11/4 11:43:00  1808人阅读

ORACLE CHARACTERSET DESCRIPTIONS FOR 9.2 

-----------------------------------------

The following is a quick reference for character set names and associated

languages. This includes brief descriptions of most languages associated with

each characterset (including informational references)

Only those documented abbreviations that are found in the 9.2 Globalization

Guide (Appendix 'A' Locale Data) are included. This is not meant to be a

comprehensive list of all languages possible in the 9i charactersets.

From the Oracle9i Database Globalization Support Guide:

Release 2 (9.2) :

Part Number A96529-01,

Appendix A Locale Data

=============================== SB=Single Byte EURO=EURO Capable

ASIAN Language Character Sets MB=Multi byte UDC=user-defined characters

===============================

Character Set Name Description Comments Language, Country or Region (Language Abbrv at bottom of Note)

================= ================================ ========= ==========================

BN8BSCII Bangladesh National Code 8-bit BSCII SB, ASCII bn

ZHT16BIG5 BIG5 16-bit Traditional Chinese MB, ASCII zht,Traditional Chinese

ZHT16HKSCS MS Windows Code Page 950 w/ Hong MB, ASCII, EURO zht,Hong Kong Supplemental characters

Kong Supplementary Character Set

ZHS16CGB231280 CGB2312-80 16-bit Simplified Chinese MB, ASCII zhs,Simplified Chinese

ZHS32GB18030 GB18030-2000 MB, ASCII, EURO zhs,Simplified Chinese

JA16EUC EUC 24-bit Japanese MB, ASCII ja

JA16EUCTILDE The same as JA16EUC except for the way MB, ASCII ja

that the wave dash and the tilde are

mapped to and from Unicode.

JA16EUCYEN EUC 24-bit Japanese with '/' mapped MB ja

to the Japanese yen character

ZHT32EUC EUC 32-bit Traditional Chinese MB, ASCII zht

ZHS16GBK GBK 16-bit Simplified Chinese MB, ASCII, UDC zhs

ZHT16CCDC HP CCDC 16-bit Traditional Chinese MB, ASCII zht

JA16DBCS IBM EBCDIC 16-bit Japanese MB, UDC ja

JA16EBCDIC930 IBM DBCS Code Page 290 16-bit Japanese MB, UDC ja

KO16DBCS IBM EBCDIC 16-bit Korean MB, UDC ko

ZHS16DBCS IBM EBCDIC 16-bit Simplified Chinese MB, UDC zhs

ZHT16DBCS IBM EBCDIC 16-bit Traditional Chinese MB, UDC sht

KO16KSC5601 KSC5601 16-bit Korean MB, ASCII ko

KO16KSCCS KSCCS 16-bit Korean MB, ASCII ko

JA16VMS JVMS 16-bit Japanese MB, ASCII ja

ZHS16MACCGB23128 Mac client CGB2312-80 16-bit Simplified Chinese MB zhs

JA16MACSJIS Mac client Shift-JIS 16-bit Japanese MB ja

TH8MACTHAI Mac Client 8-bit Latin/Thai SB th,Latin

TH8MACTHAIS Mac Server 8-bit Latin/Thai SB, ASCII th,Latin

TH8TISEBCDICS Thai Industrial Standard SB th

620-2533-EBCDIC Server 8-bit

ZHT16MSWIN950 MS Windows Code Page 950 Traditional Chinese MB, ASCII, UDC zht

KO16MSWIN949 MS Windows Code Page 949 Korean MB, ASCII, UDC ko

VN8MSWIN1258 MS Windows Code Page 1258 8-bit Vietnamese SB, ASCII, EURO vn

IN8ISCII Multiple-Script Indian Standard 8-bit SB, ASCII Indian,Latin

Latin/Indian Languages

JA16SJIS Shift-JIS 16-bit Japanese MB, ASCII, UDC ja

JA16SJISTILDE The same as JA16SJIS except for the way that MB, ASCII, UDC ja

the wave dash and the tilde are mapped

to and from Unicode.

JA16SJISYEN Shift-JIS 16-bit Japanese with MB, UDC ja

'/' mapped to the Japanese yen character

ZHT32SOPS SOPS 32-bit Traditional Chinese MB, ASCII zht

ZHT16DBT Taiwan Taxation 16-bit Traditional Chinese MB, ASCII zht

TH8TISASCII Thai Industrial Standard 620-2533 ASCII 8-bit SB, ASCII, EURO th

(Oracle's definition includes the Microsoft Windows Codepage 874 addons to 620-2533)

TH8TISEBCDIC Thai Industrial Standard 620-2533 EBCDIC 8-bit SB th

ZHT32TRIS TRIS 32-bit Traditional Chinese MB, ASCII zht

AL16UTF16 See "Universal Character Sets" for details MB, EURO, FIXED Universal Unicode

AL32UTF8 See "Universal Character Sets" for details MB, ASCII, EURO Universal Unicode

UTF8 See "Universal Character Sets" for details MB, ASCII, EURO Universal Unicode

UTFE See "Universal Character Sets" for details MB, EURO Universal Unicode

VN8VN3 VN3 8-bit Vietnamese SB, ASCII vn

=================================

EUROPEAN Language Character Sets

=================================

Character Set Name Description Comments Language, Country or Region

================= ================================ ========= ==========================

US7ASCII ASCII 7-bit American SB, ASCII us

SF7ASCII ASCII 7-bit Finnish SB sf,

YUG7ASCII ASCII 7-bit Yugoslavian SB Yugoslavian

RU8BESTA BESTA 8-bit Latin/Cyrillic SB, ASCII Latin,Cyrillic

EL8GCOS7 Bull EBCDIC GCOS7 8-bit Greek SB el

WE8GCOS7 Bull EBCDIC GCOS7 8-bit West European SB West European

EL8DEC DEC 8-bit Latin/Greek SB el,Latin

TR7DEC DEC VT100 7-bit Turkish SB tr

TR8DEC DEC 8-bit Turkish SB, ASCII tr

TR8EBCDIC1026 EBCDIC Code Page 1026 8-bit Turkish SB tr

TR8EBCDIC1026S EBCDIC Code Page 1026 Server 8-bit Turkish SB tr

TR8PC857 IBM-PC Code Page 857 8-bit Turkish SB, ASCII tr

TR8MACTURKISH MAC Client 8-bit Turkish SB tr

TR8MACTURKISHS MAC Server 8-bit Turkish SB, ASCII tr

TR8MSWIN1254 MS Windows Code Page 1254 8-bit Turkish SB, ASCII, EURO tr

WE8BS2000L5 Siemens EBCDIC.DF.L5 8-bit SB tr,West European

West European/Turkish

WE8DEC DEC 8-bit West European SB, ASCII West European

D7DEC DEC VT100 7-bit German SB d

F7DEC DEC VT100 7-bit French SB f

S7DEC DEC VT100 7-bit Swedish SB s

E7DEC DEC VT100 7-bit Spanish SB e

NDK7DEC DEC VT100 7-bit Norwegian/Danish SB n,dk

I7DEC DEC VT100 7-bit Italian SB i

NL7DEC DEC VT100 7-bit Dutch SB nl

CH7DEC DEC VT100 7-bit Swiss (German/French) SB d,f

SF7DEC DEC VT100 7-bit Finnish SB sf

WE8DG DG 8-bit West European SB,ASCII West European

WE8EBCDIC37C EBCDIC Code Page 37 8-bit Oracle/c SB

WE8EBCDIC37 EBCDIC Code Page 37 8-bit West European SB West European

D8EBCDIC273 EBCDIC Code Page 273/1 8-bit Austrian German SB d

DK8EBCDIC277 EBCDIC Code Page 277/1 8-bit Danish SB dk

S8EBCDIC278 EBCDIC Code Page 278/1 8-bit Swedish SB s

I8EBCDIC280 EBCDIC Code Page 280/1 8-bit Italian SB i

WE8EBCDIC284 EBCDIC Code Page 284 8-bit SB e

Latin American/Spanish

WE8EBCDIC285 EBCDIC Code Page 285 8-bit West European SB West European

WE8EBCDIC924 Latin 9 EBCDIC 924 SB,EBCDIC Latin

WE8EBCDIC1047 EBCDIC Code Page 1047 8-bit West European SB West European

WE8EBCDIC1047E Latin 1/Open Systems 1047 SB,EBCDIC,EURO Latin

WE8EBCDIC1140 EBCDIC Code Page 1140 8-bit West European SB,EURO West European

WE8EBCDIC1140C EBCDIC Code Page 1140 Client 8-bit SB,EURO West European

West European

WE8EBCDIC1145 EBCDIC Code Page 1145 8-bit West European SB,EURO West European

WE8EBCDIC1146 EBCDIC Code Page 1146 8-bit West European SB,EURO West European

WE8EBCDIC1148 EBCDIC Code Page 1148 8-bit West European SB,EURO West European

WE8EBCDIC1148C EBCDIC Code Page 1148 Client 8-bit WestEuropean SB,EURO West European

F8EBCDIC297 EBCDIC Code Page 297 8-bit French SB f

WE8EBCDIC500C EBCDIC Code Page 500 8-bit Oracle/c SB

WE8EBCDIC500 EBCDIC Code Page 500 8-bit West European SB West European

EE8EBCDIC870 EBCDIC Code Page 870 8-bit East European SB East European

EE8EBCDIC870C EBCDIC Code Page 870 Client 8-bit East European SB East European

EE8EBCDIC870S EBCDIC Code Page 870 Server 8-bit SB East European

East European

WE8EBCDIC871 EBCDIC Code Page 871 8-bit Icelandic SB is

EL8EBCDIC875 EBCDIC Code Page 875 8-bit Greek SB el

EL8EBCDIC875R EBCDIC Code Page 875 Server 8-bit Greek SB el

CL8EBCDIC1025 EBCDIC Code Page 1025 8-bit Cyrillic SB Cyrillic

CL8EBCDIC1025C EBCDIC Code Page 1025 Client 8-bit Cyrillic SB Cyrillic

CL8EBCDIC1025R EBCDIC Code Page 1025 Server 8-bit Cyrillic SB Cyrillic

CL8EBCDIC1025S EBCDIC Code Page 1025 Server 8-bit Cyrillic SB Cyrillic

CL8EBCDIC1025X EBCDIC Code Page 1025 (Modified)8-bit Cyrillic SB Cyrillic

BLT8EBCDIC1112 EBCDIC Code Page 1112 8-bit Baltic Multilingual SB Baltic Multilingual

BLT8EBCDIC1112S EBCDIC Code Page 1112 8-bit Server SB Baltic Multilingual

Baltic Multilingual

D8EBCDIC1141 EBCDIC Code Page 1141 8-bit Austrian German SB, EURO d

DK8EBCDIC1142 EBCDIC Code Page 1142 8-bit Danish SB, EURO dk

S8EBCDIC1143 EBCDIC Code Page 1143 8-bit Swedish SB, EURO s

I8EBCDIC1144 EBCDIC Code Page 1144 8-bit Italian SB, EURO i

F8EBCDIC1147 EBCDIC Code Page 1147 8-bit French SB, EURO f

EEC8EUROASCI EEC Targon 35 ASCI West European/Greek SB el,West European

EEC8EUROPA3 EEC EUROPA3 8-bit West European/Greek SB el,West European

LA8PASSPORT German Government Printer 8-bit SB, ASCII d,All European Printer

All-European Latin

WE8HP HP LaserJet 8-bit West European SB West European

WE8ROMAN8 HP Roman8 8-bit West European SB, ASCII West European

HU8CWI2 Hungarian 8-bit CWI-2 SB, ASCII hu

HU8ABMOD Hungarian 8-bit Special AB Mod SB, ASCII hu

LV8RST104090 IBM-PC Alternative Code Page 8-bit SB, ASCII lv,Cyrillic

Latvian (Latin/Cyrillic)

US8PC437 IBM-PC Code Page 437 8-bit American SB, ASCII us

BG8PC437S IBM-PC Code Page 437 8-bit SB, ASCII bg

(Bulgarian Modification)

EL8PC437S IBM-PC Code Page 437 8-bit (Greek modification) SB, ASCII el

EL8PC737 IBM-PC Code Page 737 8-bit Greek/Latin SB el,Latin

LT8PC772 IBM-PC Code Page 772 8-bit Lithuanian SB, ASCII Latin,Cyrillic

(Latin/Cyrillic)

LT8PC774 IBM-PC Code Page 774 8-bit Lithuanian (Latin) SB, ASCII lt,Latin

BLT8PC775 IBM-PC Code Page 775 8-bit Baltic SB, ASCII Baltic

WE8PC850 IBM-PC Code Page 850 8-bit West European SB, ASCII West European

EL8PC851 IBM-PC Code Page 851 8-bit Greek/Latin SB, ASCII el,Latin

EE8PC852 IBM-PC Code Page 852 8-bit East European SB, ASCII East European

RU8PC855 IBM-PC Code Page 855 8-bit Latin/Cyrillic SB, ASCII Latin,Cyrillic

WE8PC858 IBM-PC Code Page 858 8-bit West European SB, ASCII, EURO West European

WE8PC860 IBM-PC Code Page 860 8-bit West European SB, ASCII West European

IS8PC861 IBM-PC Code Page 861 8-bit Icelandic SB, ASCII is

CDN8PC863 IBM-PC Code Page 863 8-bit Canadian French SB, ASCII f,Canadian French

N8PC865 IBM-PC Code Page 865 8-bit Norwegian SB, ASCII n

RU8PC866 IBM-PC Code Page 866 8-bit Latin/Cyrillic SB, ASCII Latin,Cyrillic

EL8PC869 IBM-PC Code Page 869 8-bit Greek/Latin SB, ASCII el,Latin

LV8PC1117 IBM-PC Code Page 1117 8-bit Latvian SB, ASCII lv

US8ICL ICL EBCDIC 8-bit American SB us

WE8ICL ICL EBCDIC 8-bit West European SB West European

WE8ISOICLUK ICL special version ISO8859-1 SB Latin,ISO8859-1 variant

WE8ISO8859P1 ISO 8859-1 West European SB, ASCII dk,nl,f,sf,d,is,i,n,pt,e,s

EE8ISO8859P2 ISO 8859-2 East European SB, ASCII cs,gb,d,hu,pl,ro,hr,sk,sl, hr

SE8ISO8859P3 ISO 8859-3 South European SB, ASCII f,d,i,pt,tr

NEE8ISO8859P4 ISO 8859-4 North and North-East European SB, ASCII dk,et,sf,d,lv,lt,n,pt,sl,s

CL8ISO8859P5 ISO 8859-5 Latin/Cyrillic SB, ASCII bg,ru,uk

AR8ISO8859P6 ISO 8859-6 Latin/Arabic SB, ASCII ar

EL8ISO8859P7 ISO 8859-7 Latin/Greek SB, ASCII, EURO el

IW8ISO8859P8 ISO 8859-8 Latin/Hebrew SB, ASCII iw

NE8ISO8859P10 ISO 8859-10 North European SB, ASCII dk,et,sf,d,is,lv,lt,n,sl,s

BLT8ISO8859P13 ISO 8859-13 Baltic SB, ASCII (?) dk,et,sf,d,is,lv,lt,n,sl,s

CEL8ISO8859P14 ISO 8859-13 Celtic SB, ASCII celtic

WE8ISO8859P15 ISO 8859-15 West European SB, ASCII, EURO ca,dk,nl,sf,f,d,i,n,pt,e,s

LA8ISO6937 ISO 6937 8-bit Coded Character Set SB, ASCII Text Communication

for Text Communication

IW7IS960 Israeli Standard 960 7-bit Latin/Hebrew SB iw,Latin

AR8ARABICMAC Mac Client 8-bit Latin/Arabic SB ar,Latin

EE8MACCE Mac Client 8-bit Central European SB Central European

EE8MACCROATIAN Mac Client 8-bit Croatian SB hr

WE8MACROMAN8 Mac Client 8-bit Extended Roman8 West European SB Latin,West European

EL8MACGREEK Mac Client 8-bit Greek SB el

IS8MACICELANDIC Mac Client 8-bit Icelandic SB is

CL8MACCYRILLIC Mac Client 8-bit Latin/Cyrillic SB Latin,Cyrillic

AR8ARABICMACS Mac Server 8-bit Latin/Arabic SB, ASCII ar,Latin

EE8MACCES Mac Server 8-bit Central European SB, ASCII Central European

EE8MACCROATIANS Mac Server 8-bit Croatian SB, ASCII hr

WE8MACROMAN8S Mac Server 8-bit Extended Roman8 West European SB, ASCII West European

CL8MACCYRILLICS Mac Server 8-bit Latin/Cyrillic SB, ASCII Latin,Cyrillic

EL8MACGREEKS Mac Server 8-bit Greek SB, ASCII el

IS8MACICELANDICS Mac Server 8-bit Icelandic SB is

BG8MSWIN MS Windows 8-bit Bulgarian Cyrillic SB, ASCII bg

LT8MSWIN921 MS Windows Code Page 921 8-bit Lithuanian SB, ASCII lt,Latin

ET8MSWIN923 MS Windows Code Page 923 8-bit Estonian SB, ASCII et

EE8MSWIN1250 MS Windows Code Page 1250 8-bit East European SB, ASCII, EURO East European

CL8MSWIN1251 MS Windows Code Page 1251 8-bit Latin/Cyrillic SB, ASCII, EURO Latin,Cyrillic

WE8MSWIN1252 MS Windows Code Page 1252 8-bit West European SB, ASCII, EURO West European

EL8MSWIN1253 MS Windows Code Page 1253 8-bit Latin/Greek SB, ASCII, EURO el,Latin

BLT8MSWIN1257 MS Windows Code Page 1257 8-bit Baltic SB, ASCII, EURO Baltic

BLT8CP921 Latvian Standard LVS8-92(1) Windows/Unix SB, ASCII Baltic

8-bit Baltic

LV8PC8LR Latvian Version IBM-PC Code Page 866 SB, ASCII Latin,Cyrillic

8-bit Latin/Cyrillic

WE8NCR4970 NCR 4970 8-bit West European SB, ASCII West European

WE8NEXTSTEP NeXTSTEP PostScript 8-bit West European SB, ASCII West European

CL8ISOIR111 ISOIR111 Cyrillic SB Cyrillic

CL8KOI8R RELCOM Internet Standard 8-bit Latin/Cyrillic SB, ASCII Latin,Cyrillic

CL8KOI8U KOI8 Ukrainian Cyrillic SB Cyrillic

US8BS2000 Siemens 9750-62 EBCDIC 8-bit American SB us

DK8BS2000 Siemens 9750-62 EBCDIC 8-bit Danish SB dk

F8BS2000 Siemens 9750-62 EBCDIC 8-bit French SB f

D8BS2000 Siemens 9750-62 EBCDIC 8-bit German SB d

E8BS2000 Siemens 9750-62 EBCDIC 8-bit Spanish SB e

S8BS2000 Siemens 9750-62 EBCDIC 8-bit Swedish SB s

DK7SIEMENS9780X Siemens 97801/97808 7-bit Danish SB dk

F7SIEMENS9780X Siemens 97801/97808 7-bit French SB f

D7SIEMENS9780X Siemens 97801/97808 7-bit German SB d

I7SIEMENS9780X Siemens 97801/97808 7-bit Italian SB i

N7SIEMENS9780X Siemens 97801/97808 7-bit Norwegian SB n

E7SIEMENS9780X Siemens 97801/97808 7-bit Spanish SB e

S7SIEMENS9780X Siemens 97801/97808 7-bit Swedish SB s

EE8BS2000 Siemens EBCDIC.DF.04 8-bit East European SB East European

WE8BS2000 Siemens EBCDIC.DF.04 8-bit West European SB West European

WE8BS2000E Siemens EBCDIC.DF.04 8-bit West European SB, EURO West European

CL8BS2000 Siemens EBCDIC.EHC.LC 8-bit Cyrillic SB Cyrillic

AL16UTF16 See "Universal Character Sets" for details MB, EURO, FIXED Universal Unicode

AL32UTF8 See "Universal Character Sets" for details MB, ASCII, EURO Universal Unicode

UTF8 See "Universal Character Sets" for details MB, ASCII, EURO Universal Unicode

UTFE See "Universal Character Sets" for details MB, EURO Universal Unicode

======================================

MIDDLE EASTERN Language Character Sets

=======================================

Character Set Name Description Comments Comments Language, Country or Region

================== ========================================= ========= ==========================

AR8APTEC715 APTEC 715 Server 8-bit Latin/Arabic SB, ASCII ar,Latin

AR8APTEC715T APTEC 715 8-bit Latin/Arabic SB ar,Latin

AR8ASMO708PLUS ASMO 708 Plus 8-bit Latin/Arabic SB, ASCII ar,Latin

AR8ASMO8X ASMO Extended 708 8-bit Latin/Arabic SB, ASCII ar,Latin

AR8ADOS710 Arabic MS-DOS 710 Server 8-bit Latin/Arabic SB, ASCII ar,Latin

AR8ADOS710T Arabic MS-DOS 710 8-bit Latin/Arabic SB ar,Latin

AR8ADOS720 Arabic MS-DOS 720 Server 8-bit Latin/Arabic SB, ASCII ar,Latin

AR8ADOS720T Arabic MS-DOS 720 8-bit Latin/Arabic SB ar,Latin

TR7DEC DEC VT100 7-bit Turkish SB tr

TR8DEC DEC 8-bit Turkish SB tr

WE8EBCDIC37C EBCDIC Code Page 37 8-bit Oracle/c SB

IW8EBCDIC424 EBCDIC Code Page 424 8-bit Latin/Hebrew SB iw,Latin

IW8EBCDIC424S EBCDIC Code Page 424 Server 8-bit Latin/Hebrew SB iw,Latin

WE8EBCDIC500C EBCDIC Code Page 500 8-bit Oracle/c SB

IW8EBCDIC1086 EBCDIC Code Page 1086 8-bit Hebrew SB iw,Latin

AR8EBCDIC420S EBCDIC Code Page 420 Server 8-bit Latin/Arabic SB ar,Latin

AR8EBCDICX EBCDIC XBASIC Server 8-bit Latin/Arabic SB ar,Latin

TR8EBCDIC1026 EBCDIC Code Page 1026 8-bit Turkish SB tr

TR8EBCDIC1026S EBCDIC Code Page 1026 Server 8-bit Turkish SB tr

AR8HPARABIC8T HP 8-bit Latin/Arabic SB ar,Latin

TR8PC857 IBM-PC Code Page 857 8-bit Turkish SB, ASCII tr

IW8PC1507 IBM-PC Code Page 1507/862 8-bit Latin/Hebrew SB, ASCII iw,Latin

AR8ISO8859P6 ISO 8859-6 Latin/Arabic SB, ASCII ar,Latin

IW8ISO8859P8 ISO 8859-8 Latin/Hebrew SB, ASCII iw,Latin

WE8ISO8859P9 ISO 8859-9 West European & Turkish SB, ASCII tr,West European

LA8ISO6937 ISO 6937 8-bit Coded Character Set SB, ASCII Text Communicat

for Text Communication

IW7IS960 Israeli Standard 960 7-bit Latin/Hebrew SB iw,Latin

IW8MACHEBREW Mac Client 8-bit Hebrew SB iw

AR8ARABICMAC Mac Client 8-bit Latin/Arabic SB ar,Latin

AR8ARABICMACT Mac 8-bit Latin/Arabic SB ar,Latin

TR8MACTURKISH Mac Client 8-bit Turkish SB tr

IW8MACHEBREWS Mac Server 8-bit Hebrew SB, ASCII iw

AR8ARABICMACS Mac Server 8-bit Latin/Arabic SB, ASCII ar,Latin

TR8MACTURKISHS Mac Server 8-bit Turkish SB, ASCII tr

TR8MSWIN1254 MS Windows Code Page 1254 8-bit Turkish SB, ASCII,EURO tr

IW8MSWIN1255 MS Windows Code Page 1255 8-bit Latin/Hebrew SB, ASCII,EURO iw,Latin

AR8MSWIN1256 MS Windows Code Page 1256 8-Bit Latin/Arabic SB, ASCII,EURO ar,Latin

IN8ISCII Multiple-Script Indian Standard SB Latin,Indian

8-bit Latin/Indian

AR8MUSSAD768 Mussa'd Alarabi/2 768 Server SB, ASCII ar,Latin

8-bit Latin/Arabic

AR8MUSSAD768T Mussa'd Alarabi/2 768 8-bit Latin/Arabic SB ar,Latin

AR8NAFITHA711 Nafitha Enhanced 711 Server 8-bit Latin/Arabic SB, ASCII ar,Latin

AR8NAFITHA711T Nafitha Enhanced 711 8-bit Latin/Arabic SB ar,Latin

AR8NAFITHA721 Nafitha International 721 Server SB, ASCII ar,Latin

8-bit Latin/Arabic

AR8NAFITHA721T Nafitha International 721 8-bit Latin/Arabic SB ar,Latin

AR8SAKHR706 SAKHR 706 Server 8-bit Latin/Arabic SB, ASCII ar,Latin

AR8SAKHR707 SAKHR 707 Server 8-bit Latin/Arabic SB, ASCII ar,Latin

AR8SAKHR707T SAKHR 707 8-bit Latin/Arabic SB ar,Latin

AR8XBASIC XBASIC 8-bit Latin/Arabic SB ar,Latin

WE8BS2000L5 Siemens EBCDIC.DF.04.L5 8-bit SB tr,West European

West European/Turkish

AL16UTF16 See "Universal Character Sets" for details MB, EURO, FIXED Universal Unicode

AL32UTF8 See "Universal Character Sets" for details MB, ASCII, EURO Universal Unicode

UTF8 See "Universal Character Sets" for details MB, ASCII, EURO Universal Unicode

UTFE See "Universal Character Sets" for details MB, EURO Universal Unicode

Universal Character Sets

====================

Character Set Name Description Comments Language, Country or Region

================= ===================================== ========= ==========================

AL16UTF16 Unicode 3.1 UTF-16Universal character set MB, EURO, FIXED Universal Unicode

AL32UTF8 Unicode 3.1 UTF-8 Universal character set MB, ASCII, EURO Universal Unicode

UTF8 Unicode 3.0 UTF-8 Universal character set MB, ASCII, EURO Universal Unicode

CESU-8 compliant

UTFE EBCDIC form of Unicode 3.0UTF-8 MB, EURO Universal Unicode

Universal character set

Languages supported by the Oracle Server and abbrevations.

===========================================================

Name and Abbreviation

-----------------------------------

AMERICAN us

ARABIC ar

ASSAMESE as

BANGLA bn

BRAZILIAN PORTUGUESE ptb

BULGARIAN bg

CANADIAN FRENCH frc

CATALAN ca

CROATIAN hr

CZECH cs

DANISH dk

DUTCH nl

EGYPTIAN eg

ENGLISH gb

ESTONIAN et

FINNISH sf

FRENCH f

GERMAN DIN din

GERMAN d

GREEK el

GUJARATI gu

HEBREW iw

HINDI hi

HUNGARIAN hu

ICELANDIC is

INDONESIAN in

ITALIAN i

JAPANESE ja

KANNADA kn

KOREAN ko

LATIN AMERICAN SPANISH esa

LATVIAN lv

LITHUANIAN lt

MALAY ms

MALAYALAM ml

MARATHI mr

MEXICAN SPANISH esm

NORWEGIAN n

ORIYA or

POLISH pl

PORTUGUESE pt

PUNJABI pa

ROMANIAN ro

RUSSIAN ru

SIMPLIFIED CHINESE zhs

SLOVAK sk

SLOVENIAN sl

SPANISH e

SWEDISH s

TAMIL ta

TELUGU te

THAI th

TRADITIONAL CHINESE zht

TURKISH tr

UKRAINIAN uk

VIETNAMESE vn

QUESTIONS & ANSWERS

-------------------

1. How can I determine the charactersets that I have for my version of Oracle?

Answer

------

SQL> SELECT UNIQUE VALUE FROM V$NLS_VALID_VALUES

WHERE PARAMETER ='CHARACTERSET';

There are:

----------

257 character sets in 9.2.0

256 character sets in 9.0.1

242 character sets in 8.1.7

2. Where can I get more information on the Charactersets, Locales and Languages associated with each characterset?

Answer

------

Besides checking for your specific NLS and Globalization questions via metalink, you should also review the following Documentation for your RDBMS Version.

References

------------

Oracle9i Database Globalization Support Guide

Release 2 (9.2)

Part Number A96529-01

Oracle9i Globalization Support Guide

Release 1 (9.0.1)

Part Number A90236-02

Oracle8i National Language Support Guide

Release 2 (8.1.6)

Part Number A76966-01

More

-----

Globalization & NLS Frequently Asked Questions (FAQ)

http://otn.oracle.com/products/oracle8i/htdocs/faq_combined.htm

3. I would like to find out more about the codepoints and charactersets?

- Where can I find this information?

Answer

------

There are some excellent resources for some of the more commonly used character sets

available in metalink and also externally.

Many of the charactersets referenced in each version of Oracle are proprietary.

- You may need to go to the source vendor Codepoints and glyphs.

For the most recent Oracle notes on OCharactersets, please review:

[NOTE:150091.1] Database Administration - Globalization Technology (NLS) Library

References

------------

Reference - Character Set Definitions (Globalization Technology (NLS) on data storage, data access and server utilities)

Definition of the WE8ISO8859P1 Character Set [NOTE:14786.1]

Definition of the WE8ISO8859P9 Character Set [NOTE:16559.1]

Definition of the WE8EBCDIC37C Character Set [NOTE:122228.1]

Which Character Set Supports Which Language [NOTE:62421.1]

Definition of the WE8DEC Character Set [NOTE:106138.1]

The difference between WE8ISO8859P1 and WE8ISO8859P15 characterset [NOTE:121627.1]

Using Locale Builder to view the definition of character sets [NOTE:223706.1]

Also:

Which Character Set Supports Which Language [NOTE:62421.1]

- Explicit WE8ISO Language Description/Listings

Oracle8i NLS Features: Languages, Sorts, Territories, Calendars, CharacterSets [NOTE:103538.1]

- Condensed 8.1.7 Locale information from Oracle8i National Language Support Guide

Globalization Support Oracle Unicode Support

- http://otn.oracle.com/tech/globalization/pdf/Unicode.PDF

Excellent external (Non-Oracle) sources include the following:

References

------------

The Unicode Consortium -- www.unicode.org

----------

XML in a Nutshell by Elliotte Rusty Harold & W. Scott Means

Chapter 5 "Internationalization" & Chapter 26 "Character Sets"

Publisher O'Reilly & Associates, Inc.

阅读全文
0 0

相关文章推荐

img
取 消
img