Yasser Oracle Blog Dive in Oracle with Yasser, Oracle Developer Courses
Pages
Home
SQL Fundamentals
SQL Fundamentals II
SQL PLUS
PL/SQL
Forms and Reports
HTML5
JavaScript
PHP
jQuery
Java
NLS_LANG
SQL SERVER
PL/SQL Collections and Records
DBMS_OUTPUT built-in package
Date and Time
PL/SQL Transactions
Ref Cursors
Bulk Binds
PL/SQL Analytic Functions
Problems and solves
Oracle Indexes
Oracle Courses
PHP
Work Samples
Record & Collection
LOOP
Conditional statements
Triggers
Object Oriented
Contact Me
Saturday, October 24, 2015
NLS_LANG
Commonly Used Values for NLS_LANG
The following table lists commonly used NLS_LANG values for various languages:
Language
NLS_LANG Value
Arabic
ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256
Brazilian Portuguese
BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1
Bulgarian
BULGARIAN_BULGARIA.CL8MSWIN1251
Canadian French
CANADIAN FRENCH_CANADA.WE8ISO8859P1
Catalan
CATALAN_CATALONIA.WE8ISO8859P1
Croatian
CROATIAN_CROATIA.EE8MSWIN1250
Czech
CZECH_CZECH REPUBLIC.EE8MSWIN1250
Danish
DANISH_DENMARK.WE8ISO8859P1
Dutch
DUTCH_THE NETHERLANDS.WE8ISO8859P1
Egyptian
ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256
English
AMERICAN_AMERICA.WE8ISO8859P1
English
(United Kingdom)
ENGLISH_UNITED KINGDOM.WE8ISO8859P1
Estonian
ESTONIAN_ESTONIA.BLT8MSWIN1257
Finnish
FINNISH_FINLAND.WE8ISO8859P1
French
FRENCH_FRANCE.WE8ISO8859P1
German
GERMAN_GERMANY.WE8ISO8859P1
Greek
GREEK_GREECE.EL8MSWIN1253
Hebrew
HEBREW_ISRAEL.IW8MSWIN1255
Hungarian
HUNGARIAN_HUNGARY.EE8MSWIN1250
Icelandic
ICELANDIC_ICELAND.WE8ISO8859P1
Indonesian
INDONESIAN_INDONESIA.WE8ISO8859P1
Italian
ITALIAN_ITALY.WE8ISO8859P1
Japanese
JAPANESE_JAPAN.JA16SJIS
Korean
KOREAN_KOREA.KO16KSC5601
Latin American Spanish
LATIN AMERICAN SPANISH_AMERICA.WE8ISO8859P1
Latvian
LATVIAN_LATVIA.BLT8MSWIN1257
Lithuanian
LITHUANIAN_LITHUANIA.BLT8MSWIN1257
Mexican Spanish
MEXICAN SPANISH_MEXICO.WE8ISO8859P1
Norwegian
NORWEGIAN_NORWAY.WE8ISO8859P1
Polish
POLISH_POLAND.EE8MSWIN1250
Portuguese
PORTUGUESE_PORTUGAL.WE8ISO8859P1
Romanian
ROMANIAN_ROMANIA.EE8MSWIN1250
Russian
RUSSIAN_CIS.CL8MSWIN1251
Simplified Chinese
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
Slovak
SLOVAK_SLOVAKIA.EE8MSWIN1250
Spanish
SPANISH_SPAIN.WE8ISO8859P1
Swedish
SWEDISH_SWEDEN.WE8ISO8859P1
Thai
THAI_THAILAND.TH8TISASCII
Traditional Chinese
TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5
Turkish
TURKISH_TURKEY.WE8ISO8859P9
Ukrainian
UKRAINIAN_UKRAINE.CL8MSWIN1251
Vietnamese
VIETNAMESE_VIETNAM.VN8VN3
Others
AMERICAN_AMERICA.US7ASCII
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment