Home -> oracle -> Oracle 8i NLS settings

National language settings

NLS_LANG syntax:
NLS_LANG=Language_territory.character set
(Note the underscore between language and teritorry, and dot between teritory and character set)
Default value: American_America.US7ASCII

Oracle supported languages

AMERICANGERMANNORWEGIAN
ARABICGERMAN DINPOLISH
BENGALIGREEKPORTUGUESE
BRAZILIAN PORTUGUESEHEBREWROMANIAN
BULGARIANHINDIRUSSIAN
CANADIAN FRENCHHUNGARIANSIMPLIFIED CHINESE
CATALANICELANDICSLOVAK
CROATIANINDONESIANSLOVENIAN
CZECHITALIANSPANISH
DANISHJAPANESESWEDISH
DUTCHKOREANTAMIL
EGYPTIANLATIN AMERICAN SPANISHTHAI
ENGLISHLATVIANTRADITIONAL CHINESE
ESTONIANLITHUANIANTURKISH
FINNISHMALAYUKRAINIAN
FRENCHMEXICAN SPANISHVIETNAMESE

Oracle supported territories

ALGERIAHUNGARYPORTUGAL
AMERICAICELANDQATAR
AUSTRALIAINDIAROMANIA
AUSTRIAINDONESIASAUDI ARABIA
BAHRAINIRAQSINGAPORE
BANGLADESHIRELANDSLOVAKIA
BELGIUMISRAELSLOVENIA
BRAZILITALYSOMALIA
BULGARIAJAPANSOUTH AFRICA
CANADAJORDANSPAIN
CATALONIAKAZAKHSTANSUDAN
CHINAKOREASWEDEN
CISKUWAITSWITZERLAND
CROATIALATVIASYRIA
CYPRUSLEBANONTAIWAN
CZECH REPUBLICLIBYATHAILAND
CZECHOSLOVAKIALITHUANIATHE NETHERLANDS
DENMARKLUXEMBOURGTUNISIA
DJIBOUTIMALAYSIATURKEY
EGYPTMAURITANIAUKRAINE
ESTONIAMEXICOUNITED ARAB EMIRATES
FINLANDMOROCCOUNITED KINGDOM
FRANCENEW ZEALANDUZBEKISTAN
GERMANYNORWAYVIETNAM
GREECEOMANYEMEN
HONG KONGPOLAND 

Oracle supported character sets

AL24UTFFSSUnicode 1.1 UTF-8 Universal character set
AR8ADOS710Arabic MS-DOS 710 Server 8-bit Latin/Arabic
AR8ADOS710TArabic MS-DOS 710 8-bit Latin/Arabic
AR8ADOS720Arabic MS-DOS 720 Server 8-bit Latin/Arabic
AR8ADOS720TArabic MS-DOS 720 8-bit Latin/Arabic
AR8APTEC715APTEC 715 Server 8-bit Latin/Arabic
AR8APTEC715TAPTEC 715 8-bit Latin/Arabic
AR8ARABICMACMac Client 8-bit Latin/Arabic
AR8ARABICMACSMac Server 8-bit Latin/Arabic
AR8ARABICMACTMac 8-bit Latin/Arabic
AR8ASMO708PLUSASMO 708 Plus 8-bit Latin/Arabic
AR8ASMO8XASMO Extended 708 8-bit Latin/Arabic
AR8EBCDIC420SEBCDIC Code Page 420 Server 8-bit Latin/Arabic
AR8EBCDICXEBCDIC XBASIC Server 8-bit Latin/Arabic
AR8HPARABIC8THP 8-bit Latin/Arabic
AR8ISO8859P6ISO 8859-6 Latin/Arabic
AR8MSWIN1256MS Windows Code Page 1256 8-Bit Latin/Arabic
AR8MUSSAD768Mussa'd Alarabi/2 768 Server 8-bit Latin/Arabic
AR8MUSSAD768TMussa'd Alarabi/2 768 8-bit Latin/Arabic
AR8NAFITHA711Nafitha Enhanced 711 Server 8-bit Latin/Arabic
AR8NAFITHA711TNafitha Enhanced 711 8-bit Latin/Arabic
AR8NAFITHA721Nafitha International 721 Server 8-bit Latin/Arabic
AR8NAFITHA721TNafitha International 721 8-bit Latin/Arabic
AR8SAKHR706SAKHR 706 Server 8-bit Latin/Arabic
AR8SAKHR707SAKHR 707 Server 8-bit Latin/Arabic
AR8SAKHR707TSAKHR 707 8-bit Latin/Arabic
AR8XBASICXBASIC 8-bit Latin/Arabic
BG8MSWINMS Windows 8-bit Bulgarian Cyrillic
BG8PC437SIBM-PC Code Page 437 8-bit (Bulgarian Modification)
BLT8CP921Latvian Standard LVS8-92(1) Windows/Unix 8-bit Baltic
BLT8EBCDIC1112EBCDIC Code Page 1112 8-bit Baltic Multilingual
BLT8EBCDIC1112SEBCDIC Code Page 1112 8-bit Server Baltic Multilingual
BLT8MSWIN1257MS Windows Code Page 1257 8-bit Baltic
BLT8PC775IBM-PC Code Page 775 8-bit Baltic
BN8BSCIIBangladesh National Code 8-bit BSCII
CDN8PC863IBM-PC Code Page 863 8-bit Canadian French
CH7DECDEC VT100 7-bit Swiss (German/French)
CL8BS2000Siemens EBCDIC.EHC.LC 8-bit Cyrillic
CL8EBCDIC1025CEBCDIC Code Page 1025 Client 8-bit Cyrillic
CL8EBCDIC1025EBCDIC Code Page 1025 8-bit Cyrillic
CL8EBCDIC1025SEBCDIC Code Page 1025 Server 8-bit Cyrillic
CL8EBCDIC1025XEBCDIC Code Page 1025 (Modified) 8-bit Cyrillic
CL8ISO8859P5ISO 8859-5 Latin/Cyrillic
CL8KOI8RRELCOM Internet Standard 8-bit Latin/Cyrillic
CL8MACCYRILLICMac Client 8-bit Latin/Cyrillic
CL8MACCYRILLICSMac Server 8-bit Latin/Cyrillic
CL8MSWIN1251MS Windows Code Page 1251 8-bit Latin/Cyrillic
D7DECDEC VT100 7-bit German
D7SIEMENS9780XSiemens 97801/97808 7-bit German
D8BS2000Siemens 9750-62 EBCDIC 8-bit German
D8EBCDIC1141EBCDIC Code Page 1141 8-bit Austrian German
D8EBCDIC273EBCDIC Code Page 273/1 8-bit Austrian German
DK7SIEMENS9780XSiemens 97801/97808 7-bit Danish
DK8BS2000Siemens 9750-62 EBCDIC 8-bit Danish
DK8EBCDIC1142EBCDIC Code Page 1142 8-bit Danish
DK8EBCDIC277EBCDIC Code Page 277/1 8-bit Danish
E7DECDEC VT100 7-bit Spanish
E7SIEMENS9780XSiemens 97801/97808 7-bit Spanish
E8BS2000Siemens 9750-62 EBCDIC 8-bit Spanish
EE8EBCDIC870CEBCDIC Code Page 870 Client 8-bit East European
EE8EBCDIC870EBCDIC Code Page 870 8-bit East European
EE8EBCDIC870SEBCDIC Code Page 870 Server 8-bit East European
EE8ISO8859P2ISO 8859-2 East European
EE8MACCEMac Client 8-bit Central European
EE8MACCESMac Server 8-bit Central European
EE8MACCROATIANMac Client 8-bit Croatian
EE8MACCROATIANSMac Server 8-bit Croatian
EE8MSWIN1250MS Windows Code Page 1250 8-bit East European
EE8PC852IBM-PC Code Page 852 8-bit East European
EEC8EUROASCIEEC Targon 35 ASCI West European/Greek
EEC8EUROPA3EEC EUROPA3 8-bit West European/Greek
EL8DECDEC 8-bit Latin/Greek
EL8EBCDIC875EBCDIC Code Page 875 8-bit Greek
EL8EBCDIC875SEBCDIC Code Page 875 Server 8-bit Greek
EL8GCOS7Bull EBCDIC GCOS7 8-bit Greek
EL8ISO8859P7ISO 8859-7 Latin/Greek
EL8MACGREEKMac Client 8-bit Greek
EL8MACGREEKSMac Server 8-bit Greek
EL8MSWIN1253MS Windows Code Page 1253 8-bit Latin/Greek
EL8PC437SIBM-PC Code Page 437 8-bit (Greek modification)
EL8PC737IBM-PC Code Page 737 8-bit Greek/Latin
EL8PC851IBM-PC Code Page 851 8-bit Greek/Latin
EL8PC869IBM-PC Code Page 869 8-bit Greek/Latin
ET8MSWIN923MS Windows Code Page 923 8-bit Estonian
F7DECDEC VT100 7-bit French
F7SIEMENS9780XSiemens 97801/97808 7-bit French
F8BS2000Siemens 9750-62 EBCDIC 8-bit French
F8EBCDIC1147EBCDIC Code Page 1147 8-bit French
F8EBCDIC297EBCDIC Code Page 297 8-bit French
HU8ABMODHungarian 8-bit Special AB Mod
HU8CWI2Hungarian 8-bit CWI-2
I7DECDEC VT100 7-bit Italian
I7SIEMENS9780XSiemens 97801/97808 7-bit Italian
I8EBCDIC1144EBCDIC Code Page 1144 8-bit Italian
I8EBCDIC280EBCDIC Code Page 280/1 8-bit Italian
IN8ISCIIMultiple-Script Indian Standard 8-bit Latin/Indian
IN8ISCIIMultiple-Script Indian Standard 8-bit Latin/Indian Languages
IS8MACICELANDICMac Client 8-bit Icelandic
IS8MACICELANDICSMac Server 8-bit Icelandic
IS8PC861IBM-PC Code Page 861 8-bit Icelandic
IW7IS960Israeli Standard 960 7-bit Latin/Hebrew
IW8EBCDIC1086EBCDIC Code Page 1086 8-bit Hebrew
IW8EBCDIC424EBCDIC Code Page 424 8-bit Latin/Hebrew
IW8EBCDIC424SEBCDIC Code Page 424 Server 8-bit Latin/Hebrew
IW8ISO8859P8ISO 8859-8 Latin/Hebrew
IW8MACHEBREWMac Client 8-bit Hebrew
IW8MACHEBREWSMac Server 8-bit Hebrew
IW8MSWIN1255MS Windows Code Page 1255 8-bit Latin/Hebrew
IW8PC1507IBM-PC Code Page 1507/862 8-bit Latin/Hebrew
JA16DBCSFIXEDIBM EBCDIC 16-bit Japanese (16-bit fixed width, no single byte)
JA16DBCSIBM EBCDIC 16-bit Japanese
JA16EBCDIC930IBM DBCS Code Page 290 16-bit Japanese
JA16EUCEUC 24-bit Japanese
JA16EUCFIXEDEUC 16-bit Japanese. A fixed-width subset of JA16EUC
JA16EUCYENEUC 24-bit Japanese with '\' mapped to the Japanese yen character
JA16MACSJISMac client Shift-JIS 16-bit Japanese
JA16SJISFIXEDShift-JIS 16-bit Japanese. A fixed-width subset of JA16SJIS
JA16SJISShift-JIS 16-bit Japanese
JA16SJISYENShift-JIS 16-bit Japanese with '\' mapped to the Japanese yen character
JA16VMSJVMS 16-bit Japanese
KO16DBCSFIXEDIBM EBCDIC 16-bit Korean (16-bit fixed-width, no single byte)
KO16DBCSIBM EBCDIC 16-bit Korean
KO16KSC5601FIXEDKSC5601 (16-bit fixed-width, no single byte)
KO16KSC5601KSC5601 16-bit Korean
KO16KSCCSKSCCS 16-bit Korean
KO16MSWIN949MS Windows Code Page 949 Korean
LA8ISO6937ISO 6937 8-bit Coded Character Set for Text Communication
LA8ISO6937ISO 6937 8-bit Coded Character Set for Text Communication
LA8PASSPORTGerman Government Printer 8-bit All-European Latin Languages
LT8MSWIN921MS Windows Code Page 921 8-bit Lithuanian
LT8PC772IBM-PC Code Page 772 8-bit Lithuanian (Latin/Cyrillic)
LT8PC774IBM-PC Code Page 774 8-bit Lithuanian (Latin)
LV8PC1117IBM-PC Code Page 1117 8-bit Latvian
LV8PC8LRLatvian Version IBM-PC Code Page 866 8-bit Latin/Cyrillic
LV8RST104090IBM-PC Alternative Code Page 8-bit Latvian (Latin/Cyrillic)
N7SIEMENS9780XSiemens 97801/97808 7-bit Norwegian
N8PC865IBM-PC Code Page 865 8-bit Norwegian
NDK7DECDEC VT100 7-bit Norwegian/Danish
NE8ISO8859P10ISO 8859-10 North European
NEE8ISO8859P4ISO 8859-4 North and North-East European
NL7DECDEC VT100 7-bit Dutch
RU8BESTABESTA 8-bit Latin/Cyrillic
RU8PC855IBM-PC Code Page 855 8-bit Latin/Cyrillic
RU8PC866IBM-PC Code Page 866 8-bit Latin/Cyrillic
S7DECDEC VT100 7-bit Swedish
S7SIEMENS9780XSiemens 97801/97808 7-bit Swedish
S8BS2000Siemens 9750-62 EBCDIC 8-bit Swedish
S8EBCDIC1143EBCDIC Code Page 1143 8-bit Swedish
S8EBCDIC278EBCDIC Code Page 278/1 8-bit Swedish
SE8ISO8859P3ISO 8859-3 South European
SF7ASCIIASCII 7-bit Finnish
SF7DECDEC VT100 7-bit Finnish
TH8MACTHAIMac Client 8-bit Latin/Thai
TH8MACTHAISMac Server 8-bit Latin/Thai
TH8TISASCIIThai Industrial Standard 620-2533 - ASCII 8-bit
TH8TISEBCDICSThai Industrial Standard 620-2533-EBCDIC Server 8-bit
TH8TISEBCDICThai Industrial Standard 620-2533 - EBCDIC 8-bit
TR7DECDEC VT100 7-bit Turkish
TR8DECDEC 8-bit Turkish
TR8EBCDIC1026EBCDIC Code Page 1026 8-bit Turkish
TR8EBCDIC1026SEBCDIC Code Page 1026 Server 8-bit Turkish
TR8MACTURKISHMAC Client 8-bit Turkish
TR8MACTURKISHSMAC Server 8-bit Turkish
TR8MSWIN1254MS Windows Code Page 1254 8-bit Turkish
TR8PC857IBM-PC Code Page 857 8-bit Turkish
US7ASCIIASCII 7-bit American
US8BS2000Siemens 9750-62 EBCDIC 8-bit American
US8ICLICL EBCDIC 8-bit American
US8PC437IBM-PC Code Page 437 8-bit American
UTF8Unicode 2.1 UTF-8 Universal character set
UTFEUTF-EBCDIC character set (EBCDIC-friendly UTF encoding of Unicode 2.1)
VN8MSWIN1258MS Windows Code Page 1258 8-bit Vietnamese
VN8VN3VN3 8-bit Vietnamese
WE8BS2000L5Siemens EBCDIC.DF.04.L5 8-bit West European/Turkish
WE8BS2000Siemens EBCDIC.DF.04 8-bit West European
WE8DECDEC 8-bit West European
WE8DGDG 8-bit West European
WE8EBCDIC1047EBCDIC Code Page 1047 8-bit West European
WE8EBCDIC1140CEBCDIC Code Page 1140 Client 8-bit West European
WE8EBCDIC1140EBCDIC Code Page 1140 8-bit West European
WE8EBCDIC1145EBCDIC Code Page 1145 8-bit West European
WE8EBCDIC1146EBCDIC Code Page 1146 8-bit West European
WE8EBCDIC1148CEBCDIC Code Page 1148 Client 8-bit West European
WE8EBCDIC1148EBCDIC Code Page 1148 8-bit West European
WE8EBCDIC284EBCDIC Code Page 284 8-bit Latin American/Spanish
WE8EBCDIC285EBCDIC Code Page 285 8-bit West European
WE8EBCDIC37CEBCDIC Code Page 37 8-bit Oracle/c
WE8EBCDIC37EBCDIC Code Page 37 8-bit West European
WE8EBCDIC500CEBCDIC Code Page 500 8-bit Oracle/c
WE8EBCDIC500EBCDIC Code Page 500 8-bit West European
WE8EBCDIC871EBCDIC Code Page 871 8-bit Icelandic
WE8GCOS7Bull EBCDIC GCOS7 8-bit West European
WE8HPHP LaserJet 8-bit West European
WE8ICLICL EBCDIC 8-bit West European
WE8ISO8859P15ISO 8859-15 West European
WE8ISO8859P1ISO 8859-1 West European
WE8ISO8859P9ISO 8859-9 West European & Turkish
WE8ISOICLUKICL special version ISO8859-1
WE8MACROMAN8Mac Client 8-bit Extended Roman8 West European
WE8MACROMAN8SMac Server 8-bit Extended Roman8 West European
WE8MSWIN1252MS Windows Code Page 1252 8-bit West European
WE8NCR4970NCR 4970 8-bit West European
WE8NEXTSTEPNeXTSTEP PostScript 8-bit West European
WE8PC850IBM-PC Code Page 850 8-bit West European
WE8PC858IBM-PC Code Page 858 8-bit West European
WE8PC860IBM-PC Code Page 860 8-bit West European
WE8ROMAN8HP Roman8 8-bit West European
YUG7ASCIIASCII 7-bit Yugoslavian
ZHS16CGB231280CGB2312-80 16-bit Simplified Chinese (16-bit fixed-width, no single byte)
ZHS16DBCSFIXEDIBM EBCDIC 16-bit Simplified Chinese (16-bit fixed-width, no single byte)
ZHS16DBCSIBM EBCDIC 16-bit Simplified Chinese
ZHS16GBKFIXEDGBK 16-bit Simplified Chinese (16-bit fixed-width, no single byte)
ZHS16GBKGBK 16-bit Simplified Chinese
ZHS16MACCGB231280Mac client CGB2312-80 16-bit Simplified Chinese
ZHT16BIG5BIG5 16-bit Traditional Chinese
ZHT16BIG5FIXEDBIG5 16-bit Traditional Chinese (16-bit fixed-width, no single byte)
ZHT16CCDCHP CCDC 16-bit Traditional Chinese
ZHT16DBCSFIXEDIBM EBCDIC 16-bit Traditional Chinese (16-bit fixed-width, no single byte)
ZHT16DBCSIBM EBCDIC 16-bit Traditional Chinese
ZHT16DBTTaiwan Taxation 16-bit Traditional Chinese
ZHT16MSWIN950MS Windows Code Page 950 Traditional Chinese
ZHT32EUCEUC 32-bit Traditional Chinese
ZHT32EUCFIXEDEUC 32-bit Traditional Chinese (32-bit fixed-width, no single byte)
ZHT32SOPSSOPS 32-bit Traditional Chinese
ZHT32TRISFIXEDTRIS 32-bit Fixed-width Traditional Chinese
ZHT32TRISTRIS 32-bit Traditional Chinese
Home -> oracle -> Oracle 8i NLS settings
Valid CSS! Valid HTML 4.01!