Oracle Forms Runtime....
4 отговора
208 прегледа
Oracle Forms Runtime....
...дейба и простотията му с простотия!
Помагайте, щото ми се изчерпиха идеите. Преди около месец ми натресоха нещо за проба, което се пуска през FormsRunitime на Оръкала. Че е тъпотия като интерфейс спор няма, но проблема ми е много шибан!
Ако във формата има поле със избор от определени стойности ( изкарва едно странно прозорче и избираш стойност от предварително зададени ) стойностите не се изписват като хората ( на кирилица ), а обикновенно само i-та. И после кюерито гърми!
Някой да има идея как да накарам простия РънТайм да попълва тези стойности на нормална кирилица, щото тази оръкласка не върши никаква работа.
Помагайте, щото ми се изчерпиха идеите. Преди около месец ми натресоха нещо за проба, което се пуска през FormsRunitime на Оръкала. Че е тъпотия като интерфейс спор няма, но проблема ми е много шибан!
Ако във формата има поле със избор от определени стойности ( изкарва едно странно прозорче и избираш стойност от предварително зададени ) стойностите не се изписват като хората ( на кирилица ), а обикновенно само i-та. И после кюерито гърми!
Някой да има идея как да накарам простия РънТайм да попълва тези стойности на нормална кирилица, щото тази оръкласка не върши никаква работа.
Re: Oracle Forms Runtime....
Опитай да промениш кодовата таблица в Registry (при клиента - там, където стартираш Forms Runtime) -
HKEY_LOCAL_MACHINE - SOFTWARE - ORACLE
ключът NLS_LANG
Например:
NLS_LANG да има стойност AMERICAN_AMERICA.CL8MSWIN1251
или BULGARIAN_BULGARIA.CL8MSWIN1251
Всъщност е добре кодовата таблица (в случая CL8MSWIN1251) да е същата, както на базата данни. Ако при базата е различна от горната таблица, тогава задай нея.
HKEY_LOCAL_MACHINE - SOFTWARE - ORACLE
ключът NLS_LANG
Например:
NLS_LANG да има стойност AMERICAN_AMERICA.CL8MSWIN1251
или BULGARIAN_BULGARIA.CL8MSWIN1251
Всъщност е добре кодовата таблица (в случая CL8MSWIN1251) да е същата, както на базата данни. Ако при базата е различна от горната таблица, тогава задай нея.
Re: Oracle Forms Runtime....
Всъщност сървъра на userenv('LANGUAGE') дава AMERICAN_AMERICA.CL8ISO8859P5, но с BULGARIAN_BULGARIA.CL8MSWIN1251 захапва идеално! 10х.
Между другото, това преди точката от локейшъна на компютъра ли идва? И откъде мога да се сдобия с всички подържани на клиента кодови таблици?
Между другото, това преди точката от локейшъна на компютъра ли идва? И откъде мога да се сдобия с всички подържани на клиента кодови таблици?
Re: Oracle Forms Runtime....
Ето таблиците (не се получава добре):
A-6 Oracle8i National Language Support Guide
Character Sets
Oracle-supported character sets are listed below, for easy reference, according to
three broad language groups:
n Asian Language Character Sets
n European Language Character Sets
n Middle Eastern Language Character Sets
Note that some character sets may be listed under multiple language groups
because they provide multilingual support. For instance, Unicode spans the Asian,
European, and Middle Eastern language groups because it supports most of the
major scripts of the world.
The comment section indicates the type of encoding used:
SB = Single-byte encoding
MB = Multi-byte encoding
FIXED = Fixed-width multi-byte encoding
As mentioned in Chapter 3, "Choosing a Character Set", the type of encoding will
affect performance, so you should use the most efficient encoding that meets your
language needs. Also, some encoding types can only be used with certain data
types. For instance, fixed-width multibyte encoded character sets 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 instance,
whether the character set supports the new Euro currency symbol, whetherഊCharacter Sets
Locale Data A-7
user-defined characters are supported for character set customization, and whether
the character set is a strict superset of ASCII (which will allow you to make use of
the ALTER DATABASE [NATIONAL] CHARACTER SET statement in case of
migration.)
EURO = Euro symbol supported
UDC = User-defined Characters supported
ASCII = Strict Superset of ASCII
Oracle does not document individual code page layouts. For specific details about a
particular character set, its character repertoire, and code point values, you should
refer to the actual national, international, or vendor-specific standards.
Asian Language Character Sets
Table A–4 lists the Oracle character sets that can support Asian languages.
Table A–4 Asian Language Character Sets
Name Description Comments
BN8BSCII Bangladesh National Code 8-bit BSCII SB, ASCII
ZHT16BIG5 BIG5 16-bit Traditional Chinese MB, ASCII
ZHS16CGB231280 CGB2312-80 16-bit Simplified Chinese MB, ASCII
JA16EUC EUC 24-bit Japanese MB, ASCII
JA16EUCYEN EUC 24-bit Japanese with '\' mapped to the Japanese yen
character
MB
JA16EUCFIXED EUC 16-bit Japanese. A fixed-width subset of JA16EUC
(contains only the 2-byte characters of JA16EUC). Contains
no 7- or 8-bit ASCII characters
FIXED
ZHT32EUC EUC 32-bit Traditional Chinese MB, ASCII
ZHT32EUCFIXED EUC 32-bit Traditional Chinese (32-bit fixed-width, no single
byte)
FIXED
ZHS16GBK GBK 16-bit Simplified Chinese MB, ASCII, UDC
ZHS16GBKFIXED GBK 16-bit Simplified Chinese (16-bit fixed-width, no single
byte)
FIXED, UDC
ZHT16CCDC HP CCDC 16-bit Traditional Chinese MB, ASCII
JA16DBCS IBM EBCDIC 16-bit Japanese MB, UDCഊCharacter Sets
A-8 Oracle8i National Language Support Guide
JA16EBCDIC930 IBM DBCS Code Page 290 16-bit Japanese MB, UDC
JA16DBCSFIXED IBM EBCDIC 16-bit Japanese (16-bit fixed width, no single
byte)
FIXED, UDC
KO16DBCS IBM EBCDIC 16-bit Korean MB, UDC
KO16DBCSFIXED IBM EBCDIC 16-bit Korean (16-bit fixed-width, no single
byte)
FIXED, UDC
ZHS16DBCS IBM EBCDIC 16-bit Simplified Chinese MB, UDC
ZHS16CGB231280
FIXED
CGB2312-80 16-bit Simplified Chinese (16-bit fixed-width, no
single byte)
FIXED
ZHS16DBCSFIXED IBM EBCDIC 16-bit Simplified Chinese (16-bit fixed-width,
no single byte)
FIXED, UDC
ZHT16DBCS IBM EBCDIC 16-bit Traditional Chinese MB, UDC
ZHT16DBCSFIXED IBM EBCDIC 16-bit Traditional Chinese (16-bit fixed-width,
no single byte)
FIXED
KO16KSC5601 KSC5601 16-bit Korean MB, ASCII
KO16KSCCS KSCCS 16-bit Korean MB, ASCII
KO16KSC5601FIXED KSC5601 (16-bit fixed-width, no single byte) FIXED
JA16VMS JVMS 16-bit Japanese MB, ASCII
ZHS16MACCGB231280 Mac client CGB2312-80 16-bit Simplified Chinese MB
JA16MACSJIS Mac client Shift-JIS 16-bit Japanese MB
TH8MACTHAI Mac Client 8-bit Latin/Thai SB
TH8MACTHAIS Mac Server 8-bit Latin/Thai SB, ASCII
TH8TISEBCDICS Thai Industrial Standard 620-2533-EBCDIC Server 8-bit SB
ZHT16MSWIN950 MS Windows Code Page 950 Traditional Chinese MB, ASCII, UDC
KO16MSWIN949 MS Windows Code Page 949 Korean MB, ASCII, UDC
VN8MSWIN1258 MS Windows Code Page 1258 8-bit Vietnamese SB, ASCII, EURO
IN8ISCII Multiple-Script Indian Standard 8-bit Latin/Indian
Languages
SB, ASCII
JA16SJIS Shift-JIS 16-bit Japanese MB, ASCII, UDC
Table A–4 Asian Language Character Sets
Name Description CommentsഊCharacter Sets
Locale Data A-9
European Language Character Sets
Table A–5 lists the Oracle character sets that can support European languages.
JA16SJISFIXED Shift-JIS 16-bit Japanese. A fixed-width subset of JA16SJIS
(contains only the 2-byte characters of JA16JIS). Contains no
7- or 8-bit ASCII characters
FIXED, UDC
JA16SJISYEN Shift-JIS 16-bit Japanese with '\' mapped to the Japanese yen
character
MB, UDC
ZHT32SOPS SOPS 32-bit Traditional Chinese MB, ASCII
ZHT16DBT Taiwan Taxation 16-bit Traditional Chinese MB, ASCII
ZHT16BIG5FIXED BIG5 16-bit Traditional Chinese (16-bit fixed-width, no single
byte)
FIXED
TH8TISASCII Thai Industrial Standard 620-2533 - ASCII 8-bit SB, ASCII, EURO
TH8TISEBCDIC Thai Industrial Standard 620-2533 - EBCDIC 8-bit SB
ZHT32TRIS TRIS 32-bit Traditional Chinese MB, ASCII
ZHT32TRISFIXED TRIS 32-bit Fixed-width Traditional Chinese FIXED
AL24UTFFSS See "Universal Character Sets" on page A-17 for details
UTF8 See "Universal Character Sets" on page A-17 for details
UTFE See "Universal Character Sets" on page A-17 for details
VN8VN3 VN3 8-bit Vietnamese SB, ASCII
Table A–5 European Language Character Sets
Name Description Comments
US7ASCII ASCII 7-bit American SB, ASCII
SF7ASCII ASCII 7-bit Finnish SB
YUG7ASCII ASCII 7-bit Yugoslavian SB
RU8BESTA BESTA 8-bit Latin/Cyrillic SB, ASCII
EL8GCOS7 Bull EBCDIC GCOS7 8-bit Greek SB
WE8GCOS7 Bull EBCDIC GCOS7 8-bit West European SB
Table A–4 Asian Language Character Sets
Name Description CommentsഊCharacter Sets
A-10 Oracle8i National Language Support Guide
EL8DEC DEC 8-bit Latin/Greek SB
TR7DEC DEC VT100 7-bit Turkish SB
TR8DEC DEC 8-bit Turkish SB, ASCII
TR8EBCDIC1026 EBCDIC Code Page 1026 8-bit Turkish SB
TR8EBCDIC1026S EBCDIC Code Page 1026 Server 8-bit Turkish SB
TR8PC857 IBM-PC Code Page 857 8-bit Turkish SB, ASCII
TR8MACTURKISH MAC Client 8-bit Turkish SB
TR8MACTURKISHS MAC Server 8-bit Turkish SB, ASCII
TR8MSWIN1254 MS Windows Code Page 1254 8-bit Turkish SB, ASCII, EURO
WE8BS2000L5 Siemens EBCDIC.DF.L5 8-bit West European/Turkish SB
WE8DEC DEC 8-bit West European SB, ASCII
D7DEC DEC VT100 7-bit German SB
F7DEC DEC VT100 7-bit French SB
S7DEC DEC VT100 7-bit Swedish SB
E7DEC DEC VT100 7-bit Spanish SB
NDK7DEC DEC VT100 7-bit Norwegian/Danish SB
I7DEC DEC VT100 7-bit Italian SB
NL7DEC DEC VT100 7-bit Dutch SB
CH7DEC DEC VT100 7-bit Swiss (German/French) SB
SF7DEC DEC VT100 7-bit Finnish SB
WE8DG DG 8-bit West European SB, ASCII
WE8EBCDIC37C EBCDIC Code Page 37 8-bit Oracle/c SB
WE8EBCDIC37 EBCDIC Code Page 37 8-bit West European SB
D8EBCDIC273 EBCDIC Code Page 273/1 8-bit Austrian German SB
DK8EBCDIC277 EBCDIC Code Page 277/1 8-bit Danish SB
S8EBCDIC278 EBCDIC Code Page 278/1 8-bit Swedish SB
I8EBCDIC280 EBCDIC Code Page 280/1 8-bit Italian SB
Table A–5 European Language Character Sets
Name Description CommentsഊCharacter Sets
Locale Data A-11
WE8EBCDIC284 EBCDIC Code Page 284 8-bit Latin American/Spanish SB
WE8EBCDIC285 EBCDIC Code Page 285 8-bit West European SB
WE8EBCDIC1047 EBCDIC Code Page 1047 8-bit West European SB
WE8EBCDIC1140 EBCDIC Code Page 1140 8-bit West European SB, EURO
WE8EBCDIC1140C EBCDIC Code Page 1140 Client 8-bit West European SB, EURO
WE8EBCDIC1145 EBCDIC Code Page 1145 8-bit West European SB, EURO
WE8EBCDIC1146 EBCDIC Code Page 1146 8-bit West European SB, EURO
WE8EBCDIC1148 EBCDIC Code Page 1148 8-bit West European SB, EURO
WE8EBCDIC1148C EBCDIC Code Page 1148 Client 8-bit West European SB, EURO
F8EBCDIC297 EBCDIC Code Page 297 8-bit French SB
WE8EBCDIC500C EBCDIC Code Page 500 8-bit Oracle/c SB
WE8EBCDIC500 EBCDIC Code Page 500 8-bit West European SB
EE8EBCDIC870 EBCDIC Code Page 870 8-bit East European SB
EE8EBCDIC870C EBCDIC Code Page 870 Client 8-bit East European SB
EE8EBCDIC870S EBCDIC Code Page 870 Server 8-bit East European SB
WE8EBCDIC871 EBCDIC Code Page 871 8-bit Icelandic SB
EL8EBCDIC875 EBCDIC Code Page 875 8-bit Greek SB
EL8EBCDIC875S EBCDIC Code Page 875 Server 8-bit Greek SB
CL8EBCDIC1025 EBCDIC Code Page 1025 8-bit Cyrillic SB
CL8EBCDIC1025C EBCDIC Code Page 1025 Client 8-bit Cyrillic SB
CL8EBCDIC1025S EBCDIC Code Page 1025 Server 8-bit Cyrillic SB
CL8EBCDIC1025X EBCDIC Code Page 1025 (Modified) 8-bit Cyrillic SB
BLT8EBCDIC1112 EBCDIC Code Page 1112 8-bit Baltic Multilingual SB
BLT8EBCDIC1112S EBCDIC Code Page 1112 8-bit Server Baltic Multilingual SB
D8EBCDIC1141 EBCDIC Code Page 1141 8-bit Austrian German SB, EURO
DK8EBCDIC1142 EBCDIC Code Page 1142 8-bit Danish SB, EURO
S8EBCDIC1143 EBCDIC Code Page 1143 8-bit Swedish SB, EURO
Table A–5 European Language Character Sets
Name Description CommentsഊCharacter Sets
A-12 Oracle8i National Language Support Guide
I8EBCDIC1144 EBCDIC Code Page 1144 8-bit Italian SB, EURO
F8EBCDIC1147 EBCDIC Code Page 1147 8-bit French SB, EURO
EEC8EUROASCI EEC Targon 35 ASCI West European/Greek SB
EEC8EUROPA3 EEC EUROPA3 8-bit West European/Greek SB
LA8PASSPORT German Government Printer 8-bit All-European Latin SB, ASCII
WE8HP HP LaserJet 8-bit West European SB
WE8ROMAN8 HP Roman8 8-bit West European SB, ASCII
HU8CWI2 Hungarian 8-bit CWI-2 SB, ASCII
HU8ABMOD Hungarian 8-bit Special AB Mod SB, ASCII
LV8RST104090 IBM-PC Alternative Code Page 8-bit Latvian (Latin/Cyrillic) SB, ASCII
US8PC437 IBM-PC Code Page 437 8-bit American SB, ASCII
BG8PC437S IBM-PC Code Page 437 8-bit (Bulgarian Modification) SB, ASCII
EL8PC437S IBM-PC Code Page 437 8-bit (Greek modification) SB, ASCII
EL8PC737 IBM-PC Code Page 737 8-bit Greek/Latin SB
LT8PC772 IBM-PC Code Page 772 8-bit Lithuanian (Latin/Cyrillic) SB, ASCII
LT8PC774 IBM-PC Code Page 774 8-bit Lithuanian (Latin) SB, ASCII
BLT8PC775 IBM-PC Code Page 775 8-bit Baltic SB, ASCII
WE8PC850 IBM-PC Code Page 850 8-bit West European SB, ASCII
EL8PC851 IBM-PC Code Page 851 8-bit Greek/Latin SB, ASCII
EE8PC852 IBM-PC Code Page 852 8-bit East European SB, ASCII
RU8PC855 IBM-PC Code Page 855 8-bit Latin/Cyrillic SB, ASCII
WE8PC858 IBM-PC Code Page 858 8-bit West European SB, ASCII, EURO
WE8PC860 IBM-PC Code Page 860 8-bit West European SB. ASCII
IS8PC861 IBM-PC Code Page 861 8-bit Icelandic SB, ASCII
CDN8PC863 IBM-PC Code Page 863 8-bit Canadian French SB, ASCII
N8PC865 IBM-PC Code Page 865 8-bit Norwegian SB. ASCII
RU8PC866 IBM-PC Code Page 866 8-bit Latin/Cyrillic SB, ASCII
Table A–5 European Language Character Sets
Name Description CommentsഊCharacter Sets
Locale Data A-13
EL8PC869 IBM-PC Code Page 869 8-bit Greek/Latin SB, ASCII
LV8PC1117 IBM-PC Code Page 1117 8-bit Latvian SB, ASCII
US8ICL ICL EBCDIC 8-bit American SB
WE8ICL ICL EBCDIC 8-bit West European SB
WE8ISOICLUK ICL special version ISO8859-1 SB
WE8ISO8859P1 ISO 8859-1 West European SB, ASCII
EE8ISO8859P2 ISO 8859-2 East European SB, ASCII
SE8ISO8859P3 ISO 8859-3 South European SB, ASCII
NEE8ISO8859P4 ISO 8859-4 North and North-East European SB, ASCII
CL8ISO8859P5 ISO 8859-5 Latin/Cyrillic SB, ASCII
AR8ISO8859P6 ISO 8859-6 Latin/Arabic SB, ASCII
EL8ISO8859P7 ISO 8859-7 Latin/Greek SB, ASCII, EURO
IW8ISO8859P8 ISO 8859-8 Latin/Hebrew SB, ASCII
NE8ISO8859P10 ISO 8859-10 North European SB, ASCII
WE8ISO8859P15 ISO 8859-15 West European SB, ASCII, EURO
LA8ISO6937 ISO 6937 8-bit Coded Character Set for Text Communication SB, ASCII
IW7IS960 Israeli Standard 960 7-bit Latin/Hebrew SB
AR8ARABICMAC Mac Client 8-bit Latin/Arabic SB
EE8MACCE Mac Client 8-bit Central European SB
EE8MACCROATIAN Mac Client 8-bit Croatian SB
WE8MACROMAN8 Mac Client 8-bit Extended Roman8 West European SB
EL8MACGREEK Mac Client 8-bit Greek SB
IS8MACICELANDIC Mac Client 8-bit Icelandic SB
CL8MACCYRILLIC Mac Client 8-bit Latin/Cyrillic SB
AR8ARABICMACS Mac Server 8-bit Latin/Arabic SB, ASCII
EE8MACCES Mac Server 8-bit Central European SB, ASCII
EE8MACCROATIANS Mac Server 8-bit Croatian SB, ASCII
Table A–5 European Language Character Sets
Name Description CommentsഊCharacter Sets
A-14 Oracle8i National Language Support Guide
WE8MACROMAN8S Mac Server 8-bit Extended Roman8 West European SB, ASCII
CL8MACCYRILLICS Mac Server 8-bit Latin/Cyrillic SB, ASCII
EL8MACGREEKS Mac Server 8-bit Greek SB, ASCII
IS8MACICELANDICS Mac Server 8-bit Icelandic SB
BG8MSWIN MS Windows 8-bit Bulgarian Cyrillic SB, ASCII
LT8MSWIN921 MS Windows Code Page 921 8-bit Lithuanian SB, ASCII
ET8MSWIN923 MS Windows Code Page 923 8-bit Estonian SB, ASCII
EE8MSWIN1250 MS Windows Code Page 1250 8-bit East European SB, ASCII, EURO
CL8MSWIN1251 MS Windows Code Page 1251 8-bit Latin/Cyrillic SB, ASCII, EURO
WE8MSWIN1252 MS Windows Code Page 1252 8-bit West European SB, ASCII, EURO
EL8MSWIN1253 MS Windows Code Page 1253 8-bit Latin/Greek SB, ASCII, EURO
BLT8MSWIN1257 MS Windows Code Page 1257 8-bit Baltic SB, ASCII, EURO
BLT8CP921 Latvian Standard LVS8-92(1) Windows/Unix 8-bit Baltic SB, ASCII
LV8PC8LR Latvian Version IBM-PC Code Page 866 8-bit Latin/Cyrillic SB, ASCII
WE8NCR4970 NCR 4970 8-bit West European SB, ASCII
WE8NEXTSTEP NeXTSTEP PostScript 8-bit West European SB, ASCII
CL8KOI8R RELCOM Internet Standard 8-bit Latin/Cyrillic SB, ASCII
US8BS2000 Siemens 9750-62 EBCDIC 8-bit American SB
DK8BS2000 Siemens 9750-62 EBCDIC 8-bit Danish SB
F8BS2000 Siemens 9750-62 EBCDIC 8-bit French SB
D8BS2000 Siemens 9750-62 EBCDIC 8-bit German SB
E8BS2000 Siemens 9750-62 EBCDIC 8-bit Spanish SB
S8BS2000 Siemens 9750-62 EBCDIC 8-bit Swedish SB
DK7SIEMENS9780X Siemens 97801/97808 7-bit Danish SB
F7SIEMENS9780X Siemens 97801/97808 7-bit French SB
D7SIEMENS9780X Siemens 97801/97808 7-bit German SB
I7SIEMENS9780X Siemens 97801/97808 7-bit Italian SB
Table A–5 European Language Character Sets
Name Description CommentsഊCharacter Sets
Locale Data A-15
Middle Eastern Language Character Sets
Table A–6 lists the Oracle character sets that can support Middle Eastern languages.
N7SIEMENS9780X Siemens 97801/97808 7-bit Norwegian SB
E7SIEMENS9780X Siemens 97801/97808 7-bit Spanish SB
S7SIEMENS9780X Siemens 97801/97808 7-bit Swedish SB
WE8BS2000 Siemens EBCDIC.DF.04 8-bit West European SB
CL8BS2000 Siemens EBCDIC.EHC.LC 8-bit Cyrillic SB
AL24UTFFSS See "Universal Character Sets" on page A-17 for details
UTF8 See "Universal Character Sets" on page A-17 for details
UTFE See "Universal Character Sets" on page A-17 for details
Table A–6 Middle Eastern Character Sets
Name Description Comments
AR8APTEC715 APTEC 715 Server 8-bit Latin/Arabic SB, ASCII
AR8APTEC715T APTEC 715 8-bit Latin/Arabic SB
AR8ASMO708PLUS ASMO 708 Plus 8-bit Latin/Arabic SB, ASCII
AR8ASMO8X ASMO Extended 708 8-bit Latin/Arabic SB, ASCII
AR8ADOS710 Arabic MS-DOS 710 Server 8-bit Latin/Arabic SB, ASCII
AR8ADOS710T Arabic MS-DOS 710 8-bit Latin/Arabic SB
AR8ADOS720 Arabic MS-DOS 720 Server 8-bit Latin/Arabic SB, ASCII
AR8ADOS720T Arabic MS-DOS 720 8-bit Latin/Arabic SB
TR7DEC DEC VT100 7-bit Turkish SB
TR8DEC DEC 8-bit Turkish SB
WE8EBCDIC37C EBCDIC Code Page 37 8-bit Oracle/c SB
IW8EBCDIC424 EBCDIC Code Page 424 8-bit Latin/Hebrew SB
IW8EBCDIC424S EBCDIC Code Page 424 Server 8-bit Latin/Hebrew SB
Table A–5 European Language Character Sets
Name Description CommentsഊCharacter Sets
A-16 Oracle8i National Language Support Guide
WE8EBCDIC500C EBCDIC Code Page 500 8-bit Oracle/c SB
IW8EBCDIC1086 EBCDIC Code Page 1086 8-bit Hebrew SB
AR8EBCDIC420S EBCDIC Code Page 420 Server 8-bit Latin/Arabic SB
AR8EBCDICX EBCDIC XBASIC Server 8-bit Latin/Arabic SB
TR8EBCDIC1026 EBCDIC Code Page 1026 8-bit Turkish SB
TR8EBCDIC1026S EBCDIC Code Page 1026 Server 8-bit Turkish SB
AR8HPARABIC8T HP 8-bit Latin/Arabic SB
TR8PC857 IBM-PC Code Page 857 8-bit Turkish SB, ASCII
IW8PC1507 IBM-PC Code Page 1507/862 8-bit Latin/Hebrew SB, ASCII
AR8ISO8859P6 ISO 8859-6 Latin/Arabic SB, ASCII
IW8ISO8859P8 ISO 8859-8 Latin/Hebrew SB, ASCII
WE8ISO8859P9 ISO 8859-9 West European & Turkish SB, ASCII
LA8ISO6937 ISO 6937 8-bit Coded Character Set for Text Communication SB, ASCII
IW7IS960 Israeli Standard 960 7-bit Latin/Hebrew SB
IW8MACHEBREW Mac Client 8-bit Hebrew SB
AR8ARABICMAC Mac Client 8-bit Latin/Arabic SB
AR8ARABICMACT Mac 8-bit Latin/Arabic SB
TR8MACTURKISH Mac Client 8-bit Turkish SB
IW8MACHEBREWS Mac Server 8-bit Hebrew SB, ASCII
AR8ARABICMACS Mac Server 8-bit Latin/Arabic SB, ASCII
TR8MACTURKISHS Mac Server 8-bit Turkish SB, ASCII
TR8MSWIN1254 MS Windows Code Page 1254 8-bit Turkish SB, ASCII, EURO
IW8MSWIN1255 MS Windows Code Page 1255 8-bit Latin/Hebrew SB, ASCII, EURO
AR8MSWIN1256 MS Windows Code Page 1256 8-Bit Latin/Arabic SB. ASCII, EURO
IN8ISCII Multiple-Script Indian Standard 8-bit Latin/Indian
Languages
SB
AR8MUSSAD768 Mussa'd Alarabi/2 768 Server 8-bit Latin/Arabic SB, ASCII
AR8MUSSAD768T Mussa'd Alarabi/2 768 8-bit Latin/Arabic SB
Table A–6 Middle Eastern Character Sets
Name Description CommentsഊCharacter Sets
AR8NAFITHA711 Nafitha Enhanced 711 Server 8-bit Latin/Arabic SB, ASCII
AR8NAFITHA711T Nafitha Enhanced 711 8-bit Latin/Arabic SB
AR8NAFITHA721 Nafitha International 721 Server 8-bit Latin/Arabic SB, ASCII
AR8NAFITHA721T Nafitha International 721 8-bit Latin/Arabic SB
AR8SAKHR706 SAKHR 706 Server 8-bit Latin/Arabic SB, ASCII
AR8SAKHR707 SAKHR 707 Server 8-bit Latin/Arabic SB, ASCII
AR8SAKHR707T SAKHR 707 8-bit Latin/Arabic SB
AR8XBASIC XBASIC 8-bit Latin/Arabic SB
WE8BS2000L5 Siemens EBCDIC.DF.04.L5 8-bit West European/Turkish SB
AL24UTFFSS See "Universal Character Sets" on page A-17 for details
UTF8 See "Universal Character Sets" on page A-17 for details
UTFE See "Universal Character Sets" on page A-17 for details
Table A–6 Middle Eastern Character Sets
Name Description Comments
A-6 Oracle8i National Language Support Guide
Character Sets
Oracle-supported character sets are listed below, for easy reference, according to
three broad language groups:
n Asian Language Character Sets
n European Language Character Sets
n Middle Eastern Language Character Sets
Note that some character sets may be listed under multiple language groups
because they provide multilingual support. For instance, Unicode spans the Asian,
European, and Middle Eastern language groups because it supports most of the
major scripts of the world.
The comment section indicates the type of encoding used:
SB = Single-byte encoding
MB = Multi-byte encoding
FIXED = Fixed-width multi-byte encoding
As mentioned in Chapter 3, "Choosing a Character Set", the type of encoding will
affect performance, so you should use the most efficient encoding that meets your
language needs. Also, some encoding types can only be used with certain data
types. For instance, fixed-width multibyte encoded character sets 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 instance,
whether the character set supports the new Euro currency symbol, whetherഊCharacter Sets
Locale Data A-7
user-defined characters are supported for character set customization, and whether
the character set is a strict superset of ASCII (which will allow you to make use of
the ALTER DATABASE [NATIONAL] CHARACTER SET statement in case of
migration.)
EURO = Euro symbol supported
UDC = User-defined Characters supported
ASCII = Strict Superset of ASCII
Oracle does not document individual code page layouts. For specific details about a
particular character set, its character repertoire, and code point values, you should
refer to the actual national, international, or vendor-specific standards.
Asian Language Character Sets
Table A–4 lists the Oracle character sets that can support Asian languages.
Table A–4 Asian Language Character Sets
Name Description Comments
BN8BSCII Bangladesh National Code 8-bit BSCII SB, ASCII
ZHT16BIG5 BIG5 16-bit Traditional Chinese MB, ASCII
ZHS16CGB231280 CGB2312-80 16-bit Simplified Chinese MB, ASCII
JA16EUC EUC 24-bit Japanese MB, ASCII
JA16EUCYEN EUC 24-bit Japanese with '\' mapped to the Japanese yen
character
MB
JA16EUCFIXED EUC 16-bit Japanese. A fixed-width subset of JA16EUC
(contains only the 2-byte characters of JA16EUC). Contains
no 7- or 8-bit ASCII characters
FIXED
ZHT32EUC EUC 32-bit Traditional Chinese MB, ASCII
ZHT32EUCFIXED EUC 32-bit Traditional Chinese (32-bit fixed-width, no single
byte)
FIXED
ZHS16GBK GBK 16-bit Simplified Chinese MB, ASCII, UDC
ZHS16GBKFIXED GBK 16-bit Simplified Chinese (16-bit fixed-width, no single
byte)
FIXED, UDC
ZHT16CCDC HP CCDC 16-bit Traditional Chinese MB, ASCII
JA16DBCS IBM EBCDIC 16-bit Japanese MB, UDCഊCharacter Sets
A-8 Oracle8i National Language Support Guide
JA16EBCDIC930 IBM DBCS Code Page 290 16-bit Japanese MB, UDC
JA16DBCSFIXED IBM EBCDIC 16-bit Japanese (16-bit fixed width, no single
byte)
FIXED, UDC
KO16DBCS IBM EBCDIC 16-bit Korean MB, UDC
KO16DBCSFIXED IBM EBCDIC 16-bit Korean (16-bit fixed-width, no single
byte)
FIXED, UDC
ZHS16DBCS IBM EBCDIC 16-bit Simplified Chinese MB, UDC
ZHS16CGB231280
FIXED
CGB2312-80 16-bit Simplified Chinese (16-bit fixed-width, no
single byte)
FIXED
ZHS16DBCSFIXED IBM EBCDIC 16-bit Simplified Chinese (16-bit fixed-width,
no single byte)
FIXED, UDC
ZHT16DBCS IBM EBCDIC 16-bit Traditional Chinese MB, UDC
ZHT16DBCSFIXED IBM EBCDIC 16-bit Traditional Chinese (16-bit fixed-width,
no single byte)
FIXED
KO16KSC5601 KSC5601 16-bit Korean MB, ASCII
KO16KSCCS KSCCS 16-bit Korean MB, ASCII
KO16KSC5601FIXED KSC5601 (16-bit fixed-width, no single byte) FIXED
JA16VMS JVMS 16-bit Japanese MB, ASCII
ZHS16MACCGB231280 Mac client CGB2312-80 16-bit Simplified Chinese MB
JA16MACSJIS Mac client Shift-JIS 16-bit Japanese MB
TH8MACTHAI Mac Client 8-bit Latin/Thai SB
TH8MACTHAIS Mac Server 8-bit Latin/Thai SB, ASCII
TH8TISEBCDICS Thai Industrial Standard 620-2533-EBCDIC Server 8-bit SB
ZHT16MSWIN950 MS Windows Code Page 950 Traditional Chinese MB, ASCII, UDC
KO16MSWIN949 MS Windows Code Page 949 Korean MB, ASCII, UDC
VN8MSWIN1258 MS Windows Code Page 1258 8-bit Vietnamese SB, ASCII, EURO
IN8ISCII Multiple-Script Indian Standard 8-bit Latin/Indian
Languages
SB, ASCII
JA16SJIS Shift-JIS 16-bit Japanese MB, ASCII, UDC
Table A–4 Asian Language Character Sets
Name Description CommentsഊCharacter Sets
Locale Data A-9
European Language Character Sets
Table A–5 lists the Oracle character sets that can support European languages.
JA16SJISFIXED Shift-JIS 16-bit Japanese. A fixed-width subset of JA16SJIS
(contains only the 2-byte characters of JA16JIS). Contains no
7- or 8-bit ASCII characters
FIXED, UDC
JA16SJISYEN Shift-JIS 16-bit Japanese with '\' mapped to the Japanese yen
character
MB, UDC
ZHT32SOPS SOPS 32-bit Traditional Chinese MB, ASCII
ZHT16DBT Taiwan Taxation 16-bit Traditional Chinese MB, ASCII
ZHT16BIG5FIXED BIG5 16-bit Traditional Chinese (16-bit fixed-width, no single
byte)
FIXED
TH8TISASCII Thai Industrial Standard 620-2533 - ASCII 8-bit SB, ASCII, EURO
TH8TISEBCDIC Thai Industrial Standard 620-2533 - EBCDIC 8-bit SB
ZHT32TRIS TRIS 32-bit Traditional Chinese MB, ASCII
ZHT32TRISFIXED TRIS 32-bit Fixed-width Traditional Chinese FIXED
AL24UTFFSS See "Universal Character Sets" on page A-17 for details
UTF8 See "Universal Character Sets" on page A-17 for details
UTFE See "Universal Character Sets" on page A-17 for details
VN8VN3 VN3 8-bit Vietnamese SB, ASCII
Table A–5 European Language Character Sets
Name Description Comments
US7ASCII ASCII 7-bit American SB, ASCII
SF7ASCII ASCII 7-bit Finnish SB
YUG7ASCII ASCII 7-bit Yugoslavian SB
RU8BESTA BESTA 8-bit Latin/Cyrillic SB, ASCII
EL8GCOS7 Bull EBCDIC GCOS7 8-bit Greek SB
WE8GCOS7 Bull EBCDIC GCOS7 8-bit West European SB
Table A–4 Asian Language Character Sets
Name Description CommentsഊCharacter Sets
A-10 Oracle8i National Language Support Guide
EL8DEC DEC 8-bit Latin/Greek SB
TR7DEC DEC VT100 7-bit Turkish SB
TR8DEC DEC 8-bit Turkish SB, ASCII
TR8EBCDIC1026 EBCDIC Code Page 1026 8-bit Turkish SB
TR8EBCDIC1026S EBCDIC Code Page 1026 Server 8-bit Turkish SB
TR8PC857 IBM-PC Code Page 857 8-bit Turkish SB, ASCII
TR8MACTURKISH MAC Client 8-bit Turkish SB
TR8MACTURKISHS MAC Server 8-bit Turkish SB, ASCII
TR8MSWIN1254 MS Windows Code Page 1254 8-bit Turkish SB, ASCII, EURO
WE8BS2000L5 Siemens EBCDIC.DF.L5 8-bit West European/Turkish SB
WE8DEC DEC 8-bit West European SB, ASCII
D7DEC DEC VT100 7-bit German SB
F7DEC DEC VT100 7-bit French SB
S7DEC DEC VT100 7-bit Swedish SB
E7DEC DEC VT100 7-bit Spanish SB
NDK7DEC DEC VT100 7-bit Norwegian/Danish SB
I7DEC DEC VT100 7-bit Italian SB
NL7DEC DEC VT100 7-bit Dutch SB
CH7DEC DEC VT100 7-bit Swiss (German/French) SB
SF7DEC DEC VT100 7-bit Finnish SB
WE8DG DG 8-bit West European SB, ASCII
WE8EBCDIC37C EBCDIC Code Page 37 8-bit Oracle/c SB
WE8EBCDIC37 EBCDIC Code Page 37 8-bit West European SB
D8EBCDIC273 EBCDIC Code Page 273/1 8-bit Austrian German SB
DK8EBCDIC277 EBCDIC Code Page 277/1 8-bit Danish SB
S8EBCDIC278 EBCDIC Code Page 278/1 8-bit Swedish SB
I8EBCDIC280 EBCDIC Code Page 280/1 8-bit Italian SB
Table A–5 European Language Character Sets
Name Description CommentsഊCharacter Sets
Locale Data A-11
WE8EBCDIC284 EBCDIC Code Page 284 8-bit Latin American/Spanish SB
WE8EBCDIC285 EBCDIC Code Page 285 8-bit West European SB
WE8EBCDIC1047 EBCDIC Code Page 1047 8-bit West European SB
WE8EBCDIC1140 EBCDIC Code Page 1140 8-bit West European SB, EURO
WE8EBCDIC1140C EBCDIC Code Page 1140 Client 8-bit West European SB, EURO
WE8EBCDIC1145 EBCDIC Code Page 1145 8-bit West European SB, EURO
WE8EBCDIC1146 EBCDIC Code Page 1146 8-bit West European SB, EURO
WE8EBCDIC1148 EBCDIC Code Page 1148 8-bit West European SB, EURO
WE8EBCDIC1148C EBCDIC Code Page 1148 Client 8-bit West European SB, EURO
F8EBCDIC297 EBCDIC Code Page 297 8-bit French SB
WE8EBCDIC500C EBCDIC Code Page 500 8-bit Oracle/c SB
WE8EBCDIC500 EBCDIC Code Page 500 8-bit West European SB
EE8EBCDIC870 EBCDIC Code Page 870 8-bit East European SB
EE8EBCDIC870C EBCDIC Code Page 870 Client 8-bit East European SB
EE8EBCDIC870S EBCDIC Code Page 870 Server 8-bit East European SB
WE8EBCDIC871 EBCDIC Code Page 871 8-bit Icelandic SB
EL8EBCDIC875 EBCDIC Code Page 875 8-bit Greek SB
EL8EBCDIC875S EBCDIC Code Page 875 Server 8-bit Greek SB
CL8EBCDIC1025 EBCDIC Code Page 1025 8-bit Cyrillic SB
CL8EBCDIC1025C EBCDIC Code Page 1025 Client 8-bit Cyrillic SB
CL8EBCDIC1025S EBCDIC Code Page 1025 Server 8-bit Cyrillic SB
CL8EBCDIC1025X EBCDIC Code Page 1025 (Modified) 8-bit Cyrillic SB
BLT8EBCDIC1112 EBCDIC Code Page 1112 8-bit Baltic Multilingual SB
BLT8EBCDIC1112S EBCDIC Code Page 1112 8-bit Server Baltic Multilingual SB
D8EBCDIC1141 EBCDIC Code Page 1141 8-bit Austrian German SB, EURO
DK8EBCDIC1142 EBCDIC Code Page 1142 8-bit Danish SB, EURO
S8EBCDIC1143 EBCDIC Code Page 1143 8-bit Swedish SB, EURO
Table A–5 European Language Character Sets
Name Description CommentsഊCharacter Sets
A-12 Oracle8i National Language Support Guide
I8EBCDIC1144 EBCDIC Code Page 1144 8-bit Italian SB, EURO
F8EBCDIC1147 EBCDIC Code Page 1147 8-bit French SB, EURO
EEC8EUROASCI EEC Targon 35 ASCI West European/Greek SB
EEC8EUROPA3 EEC EUROPA3 8-bit West European/Greek SB
LA8PASSPORT German Government Printer 8-bit All-European Latin SB, ASCII
WE8HP HP LaserJet 8-bit West European SB
WE8ROMAN8 HP Roman8 8-bit West European SB, ASCII
HU8CWI2 Hungarian 8-bit CWI-2 SB, ASCII
HU8ABMOD Hungarian 8-bit Special AB Mod SB, ASCII
LV8RST104090 IBM-PC Alternative Code Page 8-bit Latvian (Latin/Cyrillic) SB, ASCII
US8PC437 IBM-PC Code Page 437 8-bit American SB, ASCII
BG8PC437S IBM-PC Code Page 437 8-bit (Bulgarian Modification) SB, ASCII
EL8PC437S IBM-PC Code Page 437 8-bit (Greek modification) SB, ASCII
EL8PC737 IBM-PC Code Page 737 8-bit Greek/Latin SB
LT8PC772 IBM-PC Code Page 772 8-bit Lithuanian (Latin/Cyrillic) SB, ASCII
LT8PC774 IBM-PC Code Page 774 8-bit Lithuanian (Latin) SB, ASCII
BLT8PC775 IBM-PC Code Page 775 8-bit Baltic SB, ASCII
WE8PC850 IBM-PC Code Page 850 8-bit West European SB, ASCII
EL8PC851 IBM-PC Code Page 851 8-bit Greek/Latin SB, ASCII
EE8PC852 IBM-PC Code Page 852 8-bit East European SB, ASCII
RU8PC855 IBM-PC Code Page 855 8-bit Latin/Cyrillic SB, ASCII
WE8PC858 IBM-PC Code Page 858 8-bit West European SB, ASCII, EURO
WE8PC860 IBM-PC Code Page 860 8-bit West European SB. ASCII
IS8PC861 IBM-PC Code Page 861 8-bit Icelandic SB, ASCII
CDN8PC863 IBM-PC Code Page 863 8-bit Canadian French SB, ASCII
N8PC865 IBM-PC Code Page 865 8-bit Norwegian SB. ASCII
RU8PC866 IBM-PC Code Page 866 8-bit Latin/Cyrillic SB, ASCII
Table A–5 European Language Character Sets
Name Description CommentsഊCharacter Sets
Locale Data A-13
EL8PC869 IBM-PC Code Page 869 8-bit Greek/Latin SB, ASCII
LV8PC1117 IBM-PC Code Page 1117 8-bit Latvian SB, ASCII
US8ICL ICL EBCDIC 8-bit American SB
WE8ICL ICL EBCDIC 8-bit West European SB
WE8ISOICLUK ICL special version ISO8859-1 SB
WE8ISO8859P1 ISO 8859-1 West European SB, ASCII
EE8ISO8859P2 ISO 8859-2 East European SB, ASCII
SE8ISO8859P3 ISO 8859-3 South European SB, ASCII
NEE8ISO8859P4 ISO 8859-4 North and North-East European SB, ASCII
CL8ISO8859P5 ISO 8859-5 Latin/Cyrillic SB, ASCII
AR8ISO8859P6 ISO 8859-6 Latin/Arabic SB, ASCII
EL8ISO8859P7 ISO 8859-7 Latin/Greek SB, ASCII, EURO
IW8ISO8859P8 ISO 8859-8 Latin/Hebrew SB, ASCII
NE8ISO8859P10 ISO 8859-10 North European SB, ASCII
WE8ISO8859P15 ISO 8859-15 West European SB, ASCII, EURO
LA8ISO6937 ISO 6937 8-bit Coded Character Set for Text Communication SB, ASCII
IW7IS960 Israeli Standard 960 7-bit Latin/Hebrew SB
AR8ARABICMAC Mac Client 8-bit Latin/Arabic SB
EE8MACCE Mac Client 8-bit Central European SB
EE8MACCROATIAN Mac Client 8-bit Croatian SB
WE8MACROMAN8 Mac Client 8-bit Extended Roman8 West European SB
EL8MACGREEK Mac Client 8-bit Greek SB
IS8MACICELANDIC Mac Client 8-bit Icelandic SB
CL8MACCYRILLIC Mac Client 8-bit Latin/Cyrillic SB
AR8ARABICMACS Mac Server 8-bit Latin/Arabic SB, ASCII
EE8MACCES Mac Server 8-bit Central European SB, ASCII
EE8MACCROATIANS Mac Server 8-bit Croatian SB, ASCII
Table A–5 European Language Character Sets
Name Description CommentsഊCharacter Sets
A-14 Oracle8i National Language Support Guide
WE8MACROMAN8S Mac Server 8-bit Extended Roman8 West European SB, ASCII
CL8MACCYRILLICS Mac Server 8-bit Latin/Cyrillic SB, ASCII
EL8MACGREEKS Mac Server 8-bit Greek SB, ASCII
IS8MACICELANDICS Mac Server 8-bit Icelandic SB
BG8MSWIN MS Windows 8-bit Bulgarian Cyrillic SB, ASCII
LT8MSWIN921 MS Windows Code Page 921 8-bit Lithuanian SB, ASCII
ET8MSWIN923 MS Windows Code Page 923 8-bit Estonian SB, ASCII
EE8MSWIN1250 MS Windows Code Page 1250 8-bit East European SB, ASCII, EURO
CL8MSWIN1251 MS Windows Code Page 1251 8-bit Latin/Cyrillic SB, ASCII, EURO
WE8MSWIN1252 MS Windows Code Page 1252 8-bit West European SB, ASCII, EURO
EL8MSWIN1253 MS Windows Code Page 1253 8-bit Latin/Greek SB, ASCII, EURO
BLT8MSWIN1257 MS Windows Code Page 1257 8-bit Baltic SB, ASCII, EURO
BLT8CP921 Latvian Standard LVS8-92(1) Windows/Unix 8-bit Baltic SB, ASCII
LV8PC8LR Latvian Version IBM-PC Code Page 866 8-bit Latin/Cyrillic SB, ASCII
WE8NCR4970 NCR 4970 8-bit West European SB, ASCII
WE8NEXTSTEP NeXTSTEP PostScript 8-bit West European SB, ASCII
CL8KOI8R RELCOM Internet Standard 8-bit Latin/Cyrillic SB, ASCII
US8BS2000 Siemens 9750-62 EBCDIC 8-bit American SB
DK8BS2000 Siemens 9750-62 EBCDIC 8-bit Danish SB
F8BS2000 Siemens 9750-62 EBCDIC 8-bit French SB
D8BS2000 Siemens 9750-62 EBCDIC 8-bit German SB
E8BS2000 Siemens 9750-62 EBCDIC 8-bit Spanish SB
S8BS2000 Siemens 9750-62 EBCDIC 8-bit Swedish SB
DK7SIEMENS9780X Siemens 97801/97808 7-bit Danish SB
F7SIEMENS9780X Siemens 97801/97808 7-bit French SB
D7SIEMENS9780X Siemens 97801/97808 7-bit German SB
I7SIEMENS9780X Siemens 97801/97808 7-bit Italian SB
Table A–5 European Language Character Sets
Name Description CommentsഊCharacter Sets
Locale Data A-15
Middle Eastern Language Character Sets
Table A–6 lists the Oracle character sets that can support Middle Eastern languages.
N7SIEMENS9780X Siemens 97801/97808 7-bit Norwegian SB
E7SIEMENS9780X Siemens 97801/97808 7-bit Spanish SB
S7SIEMENS9780X Siemens 97801/97808 7-bit Swedish SB
WE8BS2000 Siemens EBCDIC.DF.04 8-bit West European SB
CL8BS2000 Siemens EBCDIC.EHC.LC 8-bit Cyrillic SB
AL24UTFFSS See "Universal Character Sets" on page A-17 for details
UTF8 See "Universal Character Sets" on page A-17 for details
UTFE See "Universal Character Sets" on page A-17 for details
Table A–6 Middle Eastern Character Sets
Name Description Comments
AR8APTEC715 APTEC 715 Server 8-bit Latin/Arabic SB, ASCII
AR8APTEC715T APTEC 715 8-bit Latin/Arabic SB
AR8ASMO708PLUS ASMO 708 Plus 8-bit Latin/Arabic SB, ASCII
AR8ASMO8X ASMO Extended 708 8-bit Latin/Arabic SB, ASCII
AR8ADOS710 Arabic MS-DOS 710 Server 8-bit Latin/Arabic SB, ASCII
AR8ADOS710T Arabic MS-DOS 710 8-bit Latin/Arabic SB
AR8ADOS720 Arabic MS-DOS 720 Server 8-bit Latin/Arabic SB, ASCII
AR8ADOS720T Arabic MS-DOS 720 8-bit Latin/Arabic SB
TR7DEC DEC VT100 7-bit Turkish SB
TR8DEC DEC 8-bit Turkish SB
WE8EBCDIC37C EBCDIC Code Page 37 8-bit Oracle/c SB
IW8EBCDIC424 EBCDIC Code Page 424 8-bit Latin/Hebrew SB
IW8EBCDIC424S EBCDIC Code Page 424 Server 8-bit Latin/Hebrew SB
Table A–5 European Language Character Sets
Name Description CommentsഊCharacter Sets
A-16 Oracle8i National Language Support Guide
WE8EBCDIC500C EBCDIC Code Page 500 8-bit Oracle/c SB
IW8EBCDIC1086 EBCDIC Code Page 1086 8-bit Hebrew SB
AR8EBCDIC420S EBCDIC Code Page 420 Server 8-bit Latin/Arabic SB
AR8EBCDICX EBCDIC XBASIC Server 8-bit Latin/Arabic SB
TR8EBCDIC1026 EBCDIC Code Page 1026 8-bit Turkish SB
TR8EBCDIC1026S EBCDIC Code Page 1026 Server 8-bit Turkish SB
AR8HPARABIC8T HP 8-bit Latin/Arabic SB
TR8PC857 IBM-PC Code Page 857 8-bit Turkish SB, ASCII
IW8PC1507 IBM-PC Code Page 1507/862 8-bit Latin/Hebrew SB, ASCII
AR8ISO8859P6 ISO 8859-6 Latin/Arabic SB, ASCII
IW8ISO8859P8 ISO 8859-8 Latin/Hebrew SB, ASCII
WE8ISO8859P9 ISO 8859-9 West European & Turkish SB, ASCII
LA8ISO6937 ISO 6937 8-bit Coded Character Set for Text Communication SB, ASCII
IW7IS960 Israeli Standard 960 7-bit Latin/Hebrew SB
IW8MACHEBREW Mac Client 8-bit Hebrew SB
AR8ARABICMAC Mac Client 8-bit Latin/Arabic SB
AR8ARABICMACT Mac 8-bit Latin/Arabic SB
TR8MACTURKISH Mac Client 8-bit Turkish SB
IW8MACHEBREWS Mac Server 8-bit Hebrew SB, ASCII
AR8ARABICMACS Mac Server 8-bit Latin/Arabic SB, ASCII
TR8MACTURKISHS Mac Server 8-bit Turkish SB, ASCII
TR8MSWIN1254 MS Windows Code Page 1254 8-bit Turkish SB, ASCII, EURO
IW8MSWIN1255 MS Windows Code Page 1255 8-bit Latin/Hebrew SB, ASCII, EURO
AR8MSWIN1256 MS Windows Code Page 1256 8-Bit Latin/Arabic SB. ASCII, EURO
IN8ISCII Multiple-Script Indian Standard 8-bit Latin/Indian
Languages
SB
AR8MUSSAD768 Mussa'd Alarabi/2 768 Server 8-bit Latin/Arabic SB, ASCII
AR8MUSSAD768T Mussa'd Alarabi/2 768 8-bit Latin/Arabic SB
Table A–6 Middle Eastern Character Sets
Name Description CommentsഊCharacter Sets
AR8NAFITHA711 Nafitha Enhanced 711 Server 8-bit Latin/Arabic SB, ASCII
AR8NAFITHA711T Nafitha Enhanced 711 8-bit Latin/Arabic SB
AR8NAFITHA721 Nafitha International 721 Server 8-bit Latin/Arabic SB, ASCII
AR8NAFITHA721T Nafitha International 721 8-bit Latin/Arabic SB
AR8SAKHR706 SAKHR 706 Server 8-bit Latin/Arabic SB, ASCII
AR8SAKHR707 SAKHR 707 Server 8-bit Latin/Arabic SB, ASCII
AR8SAKHR707T SAKHR 707 8-bit Latin/Arabic SB
AR8XBASIC XBASIC 8-bit Latin/Arabic SB
WE8BS2000L5 Siemens EBCDIC.DF.04.L5 8-bit West European/Turkish SB
AL24UTFFSS See "Universal Character Sets" on page A-17 for details
UTF8 See "Universal Character Sets" on page A-17 for details
UTFE See "Universal Character Sets" on page A-17 for details
Table A–6 Middle Eastern Character Sets
Name Description Comments
Re: Oracle Forms Runtime....
Може да се вземе от ръководството:
National Language Support Guide
Release 2 (8.1.6)
December 1999
Part No. A76966-01
При инсталиране езикът и територията (BULGARIAN_BULGARIA или AMERICAN_AMERICA и т.н.) се вземат от регионалните настройки на компютъра, но повечето хора не им обръщат внимание, та е възможно инсталаторът да не избере подходящите. Става дума, обаче, за Universal Installer, който се появи с Oracle 8.1.6, ако не се лъжа. В средата на Windows 2000 Professional, NT и Windows XP няма грешка, стига разбира се рег. настройки да са в ред.
Това го повтарям, защото наскоро имах проблеми с Windows XP, OEM инсталация - трябваше да ги доинсталирам тези рег. настройки. А компютрите все пак бяха Fujitsu/Siemens и уж всичко им беше наред.
Правил ли си връзка от Oracle Forms през ODBC с не-Oracle база данни?
Но инсталаторът при Oracle Forms 6i е по-стар. Не бива много да се разчита на него. След инсталацията на Oracle Forms (инсталира по подразбиране и Oracle Client) дори рег. настройки да са наред пак трябва да се погледне NLS_LANG и да се коригира, ако трябва.
National Language Support Guide
Release 2 (8.1.6)
December 1999
Part No. A76966-01
При инсталиране езикът и територията (BULGARIAN_BULGARIA или AMERICAN_AMERICA и т.н.) се вземат от регионалните настройки на компютъра, но повечето хора не им обръщат внимание, та е възможно инсталаторът да не избере подходящите. Става дума, обаче, за Universal Installer, който се появи с Oracle 8.1.6, ако не се лъжа. В средата на Windows 2000 Professional, NT и Windows XP няма грешка, стига разбира се рег. настройки да са в ред.
Това го повтарям, защото наскоро имах проблеми с Windows XP, OEM инсталация - трябваше да ги доинсталирам тези рег. настройки. А компютрите все пак бяха Fujitsu/Siemens и уж всичко им беше наред.
Правил ли си връзка от Oracle Forms през ODBC с не-Oracle база данни?
Но инсталаторът при Oracle Forms 6i е по-стар. Не бива много да се разчита на него. След инсталацията на Oracle Forms (инсталира по подразбиране и Oracle Client) дори рег. настройки да са наред пак трябва да се погледне NLS_LANG и да се коригира, ако трябва.