Globalization

NLS_LANGUAGE to NLS_TERRITORY Mapping Table

NLS_LANGUAGE to NLS_TERRITORY

Here in this post is the mapping table for showing NLS_LANGUAGE to their respective NLS_TERRITORY. In some situations, you may need this mapping table to solve globalization problems.

In order to change NLS_TERRITORY, you can change NLS_LANGUAGE by setting the environment variable NLS_LANG at OS-level, database sessions will use the value to changeNLS_TERRITORY.

Mapping Table

NLS_LANGUAGENLS_TERRITORY
ALBANIANALBANIA
AMERICANAMERICA
AMHARICETHIOPIA
ARABICUNITED ARAB EMIRATES
ARMENIANARMENIA
ASSAMESEINDIA
AZERBAIJANIAZERBAIJAN
BANGLAINDIA
BASQUESPAIN
BELARUSIANBELARUS
BRAZILIAN PORTUGUESEBRAZIL
BULGARIANBULGARIA
CANADIAN FRENCHCANADA
CATALANCATALONIA
CROATIANCROATIA
CYRILLIC KAZAKHKAZAKHSTAN
CYRILLIC SERBIANSERBIA
CYRILLIC UZBEKUZBEKISTAN
CZECHCZECH REPUBLIC
DANISHDENMARK
DARIAFGHANISTAN
DIVEHIMALDIVES
DUTCHTHE NETHERLANDS
EGYPTIANEGYPT
ENGLISHUNITED KINGDOM
ESTONIANESTONIA
FINNISHFINLAND
FRENCHFRANCE
GERMANGERMANY
GERMAN DINGERMANY
GREEKGREECE
GUJARATIINDIA
HEBREWISRAEL
HINDIINDIA
HUNGARIANHUNGARY
ICELANDICICELAND
INDONESIANINDONESIA
IRISHIRELAND
ITALIANITALY
JAPANESEJAPAN
KANNADAINDIA
KHMERCAMBODIA
KOREANKOREA
LAOLAOS
LATIN AMERICAN SPANISHAMERICA
LATIN BOSNIANBOSNIA AND HERZEGOVINA
LATIN SERBIANSERBIA
LATIN UZBEKUZBEKISTAN
LATVIANLATVIA
LITHUANIANLITHUANIA
MACEDONIANFYR MACEDONIA
MALAYMALAYSIA
MALAYALAMINDIA
MALTESEMALTA
MARATHIINDIA
MEXICAN SPANISHMEXICO
NEPALINEPAL
NORWEGIANNORWAY
ORIYAINDIA
PERSIANIRAN
POLISHPOLAND
PORTUGUESEPORTUGAL
PUNJABIINDIA
ROMANIANROMANIA
RUSSIANRUSSIA
SIMPLIFIED CHINESECHINA
SINHALASRI LANKA
SLOVAKSLOVAKIA
SLOVENIANSLOVENIA
SPANISHSPAIN
SWAHILIKENYA
SWEDISHSWEDEN
TAMILINDIA
TELUGUINDIA
THAITHAILAND
TRADITIONAL CHINESETAIWAN
TURKISHTURKEY
TURKMENTURKMENISTAN
UKRAINIANUKRAINE
URDUPAKISTAN
VIETNAMESEVIETNAM

For more explanations on format elements, please refer to Oracle 19c SQL Language Reference: Datetime Format Models.

Leave a Reply

Your email address will not be published. Required fields are marked *