Collation locales supported by Snowflake

Collation allows you to specify alternative rules for comparing strings, which can be used to compare and sort data according to a particular language or other user-specified rules. For more information, see Collation support.

Snowflake collation supports the locales in the following table. The table lists each supported locale and its associated language.

LocaleLanguage
afAfrikaans
af_naAfrikaans (Namibia)
af_zaAfrikaans (South Africa)
agqAghem
agq_cmAghem (Cameroon)
akAkan
ak_ghAkan (Ghana)
amAmharic
am_etAmharic (Ethiopia)
arArabic
ar_001Arabic (World)
ar_aeArabic (United Arab Emirates)
ar_bhArabic (Bahrain)
ar_djArabic (Djibouti)
ar_dzArabic (Algeria)
ar_egArabic (Egypt)
ar_ehArabic (Western Sahara)
ar_erArabic (Eritrea)
ar_ilArabic (Israel)
ar_iqArabic (Iraq)
ar_joArabic (Jordan)
ar_kmArabic (Comoros)
ar_kwArabic (Kuwait)
ar_lbArabic (Lebanon)
ar_lyArabic (Libya)
ar_maArabic (Morocco)
ar_mrArabic (Mauritania)
ar_omArabic (Oman)
ar_psArabic (Palestinian Territories)
ar_qaArabic (Qatar)
ar_saArabic (Saudi Arabia)
ar_sdArabic (Sudan)
ar_soArabic (Somalia)
ar_ssArabic (South Sudan)
ar_syArabic (Syria)
ar_tdArabic (Chad)
ar_tnArabic (Tunisia)
ar_yeArabic (Yemen)
asAssamese
as_inAssamese (India)
asaAsu
asa_tzAsu (Tanzania)
astAsturian
ast_esAsturian (Spain)
azAzerbaijani
az_cyrlAzerbaijani (Cyrillic)
az_cyrl_azAzerbaijani (Cyrillic, Azerbaijan)
az_latnAzerbaijani (Latin)
az_latn_azAzerbaijani (Latin, Azerbaijan)
basBasaa
bas_cmBasaa (Cameroon)
beBelarusian
be_byBelarusian (Belarus)
bemBemba
bem_zmBemba (Zambia)
bezBena
bez_tzBena (Tanzania)
bgBulgarian
bg_bgBulgarian (Bulgaria)
bmBambara
bm_mlBambara (Mali)
bnBangla
bn_bdBangla (Bangladesh)
bn_inBangla (India)
boTibetan
bo_cnTibetan (China)
bo_inTibetan (India)
brBreton
br_frBreton (France)
brxBodo
brx_inBodo (India)
bsBosnian
bs_cyrlBosnian (Cyrillic)
bs_cyrl_baBosnian (Cyrillic, Bosnia & Herzegovina)
bs_latnBosnian (Latin)
bs_latn_baBosnian (Latin, Bosnia & Herzegovina)
caCatalan
ca_adCatalan (Andorra)
ca_esCatalan (Spain)
ca_frCatalan (France)
ca_itCatalan (Italy)
ccpChakma
ccp_bdChakma (Bangladesh)
ccp_inChakma (India)
ceChechen
ce_ruChechen (Russia)
cggChiga
cgg_ugChiga (Uganda)
chrCherokee
chr_usCherokee (United States)
ckbCentral Kurdish
ckb_iqCentral Kurdish (Iraq)
ckb_irCentral Kurdish (Iran)
csCzech
cs_czCzech (Czechia)
cyWelsh
cy_gbWelsh (United Kingdom)
daDanish
da_dkDanish (Denmark)
da_glDanish (Greenland)
davTaita
dav_keTaita (Kenya)
deGerman
de_atGerman (Austria)
de_beGerman (Belgium)
de_chGerman (Switzerland)
de_deGerman (Germany)
de_itGerman (Italy)
de_liGerman (Liechtenstein)
de_luGerman (Luxembourg)
djeZarma
dje_neZarma (Niger)
dsbLower Sorbian
dsb_deLower Sorbian (Germany)
duaDuala
dua_cmDuala (Cameroon)
dyoJola-Fonyi
dyo_snJola-Fonyi (Senegal)
dzDzongkha
dz_btDzongkha (Bhutan)
ebuEmbu
ebu_keEmbu (Kenya)
eeEwe
ee_ghEwe (Ghana)
ee_tgEwe (Togo)
elGreek
el_cyGreek (Cyprus)
el_grGreek (Greece)
enEnglish
en_001English (World)
en_150English (Europe)
en_agEnglish (Antigua & Barbuda)
en_aiEnglish (Anguilla)
en_asEnglish (American Samoa)
en_atEnglish (Austria)
en_auEnglish (Australia)
en_bbEnglish (Barbados)
en_beEnglish (Belgium)
en_biEnglish (Burundi)
en_bmEnglish (Bermuda)
en_bsEnglish (Bahamas)
en_bwEnglish (Botswana)
en_bzEnglish (Belize)
en_caEnglish (Canada)
en_ccEnglish (Cocos [Keeling] Islands)
en_chEnglish (Switzerland)
en_ckEnglish (Cook Islands)
en_cmEnglish (Cameroon)
en_cxEnglish (Christmas Island)
en_cyEnglish (Cyprus)
en_deEnglish (Germany)
en_dgEnglish (Diego Garcia)
en_dkEnglish (Denmark)
en_dmEnglish (Dominica)
en_erEnglish (Eritrea)
en_fiEnglish (Finland)
en_fjEnglish (Fiji)
en_fkEnglish (Falkland Islands)
en_fmEnglish (Micronesia)
en_gbEnglish (United Kingdom)
en_gdEnglish (Grenada)
en_ggEnglish (Guernsey)
en_ghEnglish (Ghana)
en_giEnglish (Gibraltar)
en_gmEnglish (Gambia)
en_guEnglish (Guam)
en_gyEnglish (Guyana)
en_hkEnglish (Hong Kong SAR China)
en_ieEnglish (Ireland)
en_ilEnglish (Israel)
en_imEnglish (Isle of Man)
en_inEnglish (India)
en_ioEnglish (British Indian Ocean Territory)
en_jeEnglish (Jersey)
en_jmEnglish (Jamaica)
en_keEnglish (Kenya)
en_kiEnglish (Kiribati)
en_knEnglish (St. Kitts & Nevis)
en_kyEnglish (Cayman Islands)
en_lcEnglish (St. Lucia)
en_lrEnglish (Liberia)
en_lsEnglish (Lesotho)
en_mgEnglish (Madagascar)
en_mhEnglish (Marshall Islands)
en_moEnglish (Macau SAR China)
en_mpEnglish (Northern Mariana Islands)
en_msEnglish (Montserrat)
en_mtEnglish (Malta)
en_muEnglish (Mauritius)
en_mwEnglish (Malawi)
en_myEnglish (Malaysia)
en_naEnglish (Namibia)
en_nfEnglish (Norfolk Island)
en_ngEnglish (Nigeria)
en_nlEnglish (Netherlands)
en_nrEnglish (Nauru)
en_nuEnglish (Niue)
en_nzEnglish (New Zealand)
en_pgEnglish (Papua New Guinea)
en_phEnglish (Philippines)
en_pkEnglish (Pakistan)
en_pnEnglish (Pitcairn Islands)
en_prEnglish (Puerto Rico)
en_pwEnglish (Palau)
en_rwEnglish (Rwanda)
en_sbEnglish (Solomon Islands)
en_scEnglish (Seychelles)
en_sdEnglish (Sudan)
en_seEnglish (Sweden)
en_sgEnglish (Singapore)
en_shEnglish (St. Helena)
en_siEnglish (Slovenia)
en_slEnglish (Sierra Leone)
en_ssEnglish (South Sudan)
en_sxEnglish (Sint Maarten)
en_szEnglish (Swaziland)
en_tcEnglish (Turks & Caicos Islands)
en_tkEnglish (Tokelau)
en_toEnglish (Tonga)
en_ttEnglish (Trinidad & Tobago)
en_tvEnglish (Tuvalu)
en_tzEnglish (Tanzania)
en_ugEnglish (Uganda)
en_umEnglish (U.S. Outlying Islands)
en_usEnglish (United States)
en_us_posixEnglish (United States, Computer)
en_vcEnglish (St. Vincent & Grenadines)
en_vgEnglish (British Virgin Islands)
en_viEnglish (U.S. Virgin Islands)
en_vuEnglish (Vanuatu)
en_wsEnglish (Samoa)
en_zaEnglish (South Africa)
en_zmEnglish (Zambia)
en_zwEnglish (Zimbabwe)
eoEsperanto
esSpanish
es_419Spanish (Latin America)
es_arSpanish (Argentina)
es_boSpanish (Bolivia)
es_brSpanish (Brazil)
es_bzSpanish (Belize)
es_clSpanish (Chile)
es_coSpanish (Colombia)
es_crSpanish (Costa Rica)
es_cuSpanish (Cuba)
es_doSpanish (Dominican Republic)
es_eaSpanish (Ceuta & Melilla)
es_ecSpanish (Ecuador)
es_esSpanish (Spain)
es_gqSpanish (Equatorial Guinea)
es_gtSpanish (Guatemala)
es_hnSpanish (Honduras)
es_icSpanish (Canary Islands)
es_mxSpanish (Mexico)
es_niSpanish (Nicaragua)
es_paSpanish (Panama)
es_peSpanish (Peru)
es_phSpanish (Philippines)
es_prSpanish (Puerto Rico)
es_pySpanish (Paraguay)
es_svSpanish (El Salvador)
es_usSpanish (United States)
es_uySpanish (Uruguay)
es_veSpanish (Venezuela)
etEstonian
et_eeEstonian (Estonia)
euBasque
eu_esBasque (Spain)
ewoEwondo
ewo_cmEwondo (Cameroon)
faPersian
fa_afPersian (Afghanistan)
fa_irPersian (Iran)
ffFulah
ff_cmFulah (Cameroon)
ff_gnFulah (Guinea)
ff_mrFulah (Mauritania)
ff_snFulah (Senegal)
fiFinnish
fi_fiFinnish (Finland)
filFilipino
fil_phFilipino (Philippines)
foFaroese
fo_dkFaroese (Denmark)
fo_foFaroese (Faroe Islands)
frFrench
fr_beFrench (Belgium)
fr_bfFrench (Burkina Faso)
fr_biFrench (Burundi)
fr_bjFrench (Benin)
fr_blFrench (St. Barthélemy)
fr_caFrench (Canada)
fr_cdFrench (Congo - Kinshasa)
fr_cfFrench (Central African Republic)
fr_cgFrench (Congo - Brazzaville)
fr_chFrench (Switzerland)
fr_ciFrench (Côte d’Ivoire)
fr_cmFrench (Cameroon)
fr_djFrench (Djibouti)
fr_dzFrench (Algeria)
fr_frFrench (France)
fr_gaFrench (Gabon)
fr_gfFrench (French Guiana)
fr_gnFrench (Guinea)
fr_gpFrench (Guadeloupe)
fr_gqFrench (Equatorial Guinea)
fr_htFrench (Haiti)
fr_kmFrench (Comoros)
fr_luFrench (Luxembourg)
fr_maFrench (Morocco)
fr_mcFrench (Monaco)
fr_mfFrench (St. Martin)
fr_mgFrench (Madagascar)
fr_mlFrench (Mali)
fr_mqFrench (Martinique)
fr_mrFrench (Mauritania)
fr_muFrench (Mauritius)
fr_ncFrench (New Caledonia)
fr_neFrench (Niger)
fr_pfFrench (French Polynesia)
fr_pmFrench (St. Pierre & Miquelon)
fr_reFrench (Réunion)
fr_rwFrench (Rwanda)
fr_scFrench (Seychelles)
fr_snFrench (Senegal)
fr_syFrench (Syria)
fr_tdFrench (Chad)
fr_tgFrench (Togo)
fr_tnFrench (Tunisia)
fr_vuFrench (Vanuatu)
fr_wfFrench (Wallis & Futuna)
fr_ytFrench (Mayotte)
furFriulian
fur_itFriulian (Italy)
fyWestern Frisian
fy_nlWestern Frisian (Netherlands)
gaIrish
ga_ieIrish (Ireland)
gdScottish Gaelic
gd_gbScottish Gaelic (United Kingdom)
glGalician
gl_esGalician (Spain)
gswSwiss German
gsw_chSwiss German (Switzerland)
gsw_frSwiss German (France)
gsw_liSwiss German (Liechtenstein)
guGujarati
gu_inGujarati (India)
guzGusii
guz_keGusii (Kenya)
gvManx
gv_imManx (Isle of Man)
haHausa
ha_ghHausa (Ghana)
ha_neHausa (Niger)
ha_ngHausa (Nigeria)
hawHawaiian
haw_usHawaiian (United States)
heHebrew
he_ilHebrew (Israel)
hiHindi
hi_inHindi (India)
hrCroatian
hr_baCroatian (Bosnia & Herzegovina)
hr_hrCroatian (Croatia)
hsbUpper Sorbian
hsb_deUpper Sorbian (Germany)
huHungarian
hu_huHungarian (Hungary)
hyArmenian
hy_amArmenian (Armenia)
idIndonesian
id_idIndonesian (Indonesia)
igIgbo
ig_ngIgbo (Nigeria)
iiSichuan Yi
ii_cnSichuan Yi (China)
isIcelandic
is_isIcelandic (Iceland)
itItalian
it_chItalian (Switzerland)
it_itItalian (Italy)
it_smItalian (San Marino)
it_vaItalian (Vatican City)
jaJapanese
ja_jpJapanese (Japan)
goNgomba
jgo_cmNgomba (Cameroon)
jmcMachame
jmc_tzMachame (Tanzania)
kaGeorgian
ka_geGeorgian (Georgia)
kabKabyle
kab_dzKabyle (Algeria)
kamKamba
kam_keKamba (Kenya)
kdeMakonde
kde_tzMakonde (Tanzania)
keaKabuverdianu
kea_cvKabuverdianu (Cape Verde)
khqKoyra Chiini
khq_mlKoyra Chiini (Mali)
kiKikuyu
ki_keKikuyu (Kenya)
kkKazakh
kk_kzKazakh (Kazakhstan)
kkjKako
kkj_cmKako (Cameroon)
klKalaallisut
kl_glKalaallisut (Greenland)
klnKalenjin
kln_keKalenjin (Kenya)
kmKhmer
km_khKhmer (Cambodia)
knKannada
kn_inKannada (India)
koKorean
ko_kpKorean (North Korea)
ko_krKorean (South Korea)
kokKonkani
kok_inKonkani (India)
ksKashmiri
ks_inKashmiri (India)
ksbShambala
ksb_tzShambala (Tanzania)
ksfBafia
ksf_cmBafia (Cameroon)
kshColognian
ksh_deColognian (Germany)
kwCornish
kw_gbCornish (United Kingdom)
kyKyrgyz
ky_kgKyrgyz (Kyrgyzstan)
lagLangi
lag_tzLangi (Tanzania)
lbLuxembourgish
lb_luLuxembourgish (Luxembourg)
lgGanda
lg_ugGanda (Uganda)
lktLakota
lkt_usLakota (United States)
lnLingala
ln_aoLingala (Angola)
ln_cdLingala (Congo - Kinshasa)
ln_cfLingala (Central African Republic)
ln_cgLingala (Congo - Brazzaville)
loLao
lo_laLao (Laos)
lrcNorthern Luri
lrc_iqNorthern Luri (Iraq)
lrc_irNorthern Luri (Iran)
ltLithuanian
lt_ltLithuanian (Lithuania)
luLuba-Katanga
lu_cdLuba-Katanga (Congo - Kinshasa)
luoLuo
luo_keLuo (Kenya)
luyLuyia
luy_keLuyia (Kenya)
lvLatvian
lv_lvLatvian (Latvia)
masMasai
mas_keMasai (Kenya)
mas_tzMasai (Tanzania)
merMeru
mer_keMeru (Kenya)
mfeMorisyen
mfe_muMorisyen (Mauritius)
mgMalagasy
mg_mgMalagasy (Madagascar)
mghMakhuwa-Meetto
mgh_mzMakhuwa-Meetto (Mozambique)
mgoMetaʼ
mgo_cmMetaʼ (Cameroon)
mkMacedonian
mk_mkMacedonian (Macedonia)
mlMalayalam
ml_inMalayalam (India)
mnMongolian
mn_mnMongolian (Mongolia)
mrMarathi
mr_inMarathi (India)
msMalay
ms_bnMalay (Brunei)
ms_myMalay (Malaysia)
ms_sgMalay (Singapore)
mtMaltese
mt_mtMaltese (Malta)
muaMundang
mua_cmMundang (Cameroon)
myBurmese
my_mmBurmese (Myanmar [Burma])
mznMazanderani
mzn_irMazanderani (Iran)
naqNama
naq_naNama (Namibia)
nbNorwegian Bokmål
nb_noNorwegian Bokmål (Norway)
nb_sjNorwegian Bokmål (Svalbard & Jan Mayen)
ndNorth Ndebele
nd_zwNorth Ndebele (Zimbabwe)
ndsLow German
nds_deLow German (Germany)
nds_nlLow German (Netherlands)
neNepali
ne_inNepali (India)
ne_npNepali (Nepal)
nlDutch
nl_awDutch (Aruba)
nl_beDutch (Belgium)
nl_bqDutch (Caribbean Netherlands)
nl_cwDutch (Curaçao)
nl_nlDutch (Netherlands)
nl_srDutch (Suriname)
nl_sxDutch (Sint Maarten)
nmgKwasio
nmg_cmKwasio (Cameroon)
nnNorwegian Nynorsk
nn_noNorwegian Nynorsk (Norway)
nnhNgiemboon
nnh_cmNgiemboon (Cameroon)
nusNuer
nus_ssNuer (South Sudan)
nynNyankole
nyn_ugNyankole (Uganda)
omOromo
om_etOromo (Ethiopia)
om_keOromo (Kenya)
orOdia
or_inOdia (India)
osOssetic
os_geOssetic (Georgia)
os_ruOssetic (Russia)
paPunjabi
pa_arabPunjabi (Arabic)
pa_arab_pkPunjabi (Arabic, Pakistan)
pa_guruPunjabi (Gurmukhi)
pa_guru_inPunjabi (Gurmukhi, India)
plPolish
pl_plPolish (Poland)
psPashto
ps_afPashto (Afghanistan)
ptPortuguese
pt_aoPortuguese (Angola)
pt_brPortuguese (Brazil)
pt_chPortuguese (Switzerland)
pt_cvPortuguese (Cape Verde)
pt_gqPortuguese (Equatorial Guinea)
pt_gwPortuguese (Guinea-Bissau)
pt_luPortuguese (Luxembourg)
pt_moPortuguese (Macau SAR China)
pt_mzPortuguese (Mozambique)
pt_ptPortuguese (Portugal)
pt_stPortuguese (São Tomé & Príncipe)
pt_tlPortuguese (Timor-Leste)
quQuechua
qu_boQuechua (Bolivia)
qu_ecQuechua (Ecuador)
qu_peQuechua (Peru)
rmRomansh
rm_chRomansh (Switzerland)
rnRundi
rn_biRundi (Burundi)
roRomanian
ro_mdRomanian (Moldova)
ro_roRomanian (Romania)
rofRombo
rof_tzRombo (Tanzania)
ruRussian
ru_byRussian (Belarus)
ru_kgRussian (Kyrgyzstan)
ru_kzRussian (Kazakhstan)
ru_mdRussian (Moldova)
ru_ruRussian (Russia)
ru_uaRussian (Ukraine)
rwKinyarwanda
rw_rwKinyarwanda (Rwanda)
rwkRwa
rwk_tzRwa (Tanzania)
sahSakha
sah_ruSakha (Russia)
saqSamburu
saq_keSamburu (Kenya)
sbpSangu
sbp_tzSangu (Tanzania)
seNorthern Sami
se_fiNorthern Sami (Finland)
se_noNorthern Sami (Norway)
se_seNorthern Sami (Sweden)
sehSena
seh_mzSena (Mozambique)
sesKoyraboro Senni
ses_mlKoyraboro Senni (Mali)
sgSango
sg_cfSango (Central African Republic)
shiTachelhit
shi_latnTachelhit (Latin)
shi_latn_maTachelhit (Latin, Morocco)
shi_tfngTachelhit (Tifinagh)
shi_tfng_maTachelhit (Tifinagh, Morocco)
siSinhala
si_lkSinhala (Sri Lanka)
skSlovak
sk_skSlovak (Slovakia)
slSlovenian
sl_siSlovenian (Slovenia)
smnInari Sami
smn_fiInari Sami (Finland)
snShona
sn_zwShona (Zimbabwe)
soSomali
so_djSomali (Djibouti)
so_etSomali (Ethiopia)
so_keSomali (Kenya)
so_soSomali (Somalia)
sqAlbanian
sq_alAlbanian (Albania)
sq_mkAlbanian (Macedonia)
sq_xkAlbanian (Kosovo)
srSerbian
sr_cyrlSerbian (Cyrillic)
sr_cyrl_baSerbian (Cyrillic, Bosnia & Herzegovina)
sr_cyrl_meSerbian (Cyrillic, Montenegro)
sr_cyrl_rsSerbian (Cyrillic, Serbia)
sr_cyrl_xkSerbian (Cyrillic, Kosovo)
sr_latnSerbian (Latin)
sr_latn_baSerbian (Latin, Bosnia & Herzegovina)
sr_latn_meSerbian (Latin, Montenegro)
sr_latn_rsSerbian (Latin, Serbia)
sr_latn_xkSerbian (Latin, Kosovo)
svSwedish
sv_axSwedish (Åland Islands)
sv_fiSwedish (Finland)
sv_seSwedish (Sweden)
swSwahili
sw_cdSwahili (Congo - Kinshasa)
sw_keSwahili (Kenya)
sw_tzSwahili (Tanzania)
sw_ugSwahili (Uganda)
taTamil
ta_inTamil (India)
ta_lkTamil (Sri Lanka)
ta_myTamil (Malaysia)
ta_sgTamil (Singapore)
teTelugu
te_inTelugu (India)
teoTeso
teo_keTeso (Kenya)
teo_ugTeso (Uganda)
tgTajik
tg_tjTajik (Tajikistan)
thThai
th_thThai (Thailand)
tiTigrinya
ti_erTigrinya (Eritrea)
ti_etTigrinya (Ethiopia)
toTongan
to_toTongan (Tonga)
trTurkish
tr_cyTurkish (Cyprus)
tr_trTurkish (Turkey)
ttTatar
tt_ruTatar (Russia)
twqTasawaq
twq_neTasawaq (Niger)
tzmCentral Atlas Tamazight
tzm_maCentral Atlas Tamazight (Morocco)
ugUyghur
ug_cnUyghur (China)
ukUkrainian
uk_uaUkrainian (Ukraine)
urUrdu
ur_inUrdu (India)
ur_pkUrdu (Pakistan)
utf8UTF-8 (Unicode ordering)
uzUzbek
uz_arabUzbek (Arabic)
uz_arab_afUzbek (Arabic, Afghanistan)
uz_cyrlUzbek (Cyrillic)
uz_cyrl_uzUzbek (Cyrillic, Uzbekistan)
uz_latnUzbek (Latin)
uz_latn_uzUzbek (Latin, Uzbekistan)
vaiVai
vai_latnVai (Latin)
vai_latn_lrVai (Latin, Liberia)
vai_vaiiVai (Vai)
vai_vaii_lrVai (Vai, Liberia)
viVietnamese
vi_vnVietnamese (Vietnam)
vunVunjo
vun_tzVunjo (Tanzania)
waeWalser
wae_chWalser (Switzerland)
woWolof
wo_snWolof (Senegal)
xogSoga
xog_ugSoga (Uganda)
yavYangben
yav_cmYangben (Cameroon)
yiYiddish
yi_001Yiddish (World)
yoYoruba
yo_bjYoruba (Benin)
yo_ngYoruba (Nigeria)
yueCantonese
yue_hansCantonese (Simplified)
yue_hans_cnCantonese (Simplified, China)
yue_hantCantonese (Traditional)
yue_hant_hkCantonese (Traditional, Hong Kong SAR China)
zghStandard Moroccan Tamazight
zgh_maStandard Moroccan Tamazight (Morocco)
zhChinese
zh_hansChinese (Simplified)
zh_hans_cnChinese (Simplified, China)
zh_hans_hkChinese (Simplified, Hong Kong SAR China)
zh_hans_moChinese (Simplified, Macau SAR China)
zh_hans_sgChinese (Simplified, Singapore)
zh_hantChinese (Traditional)
zh_hant_hkChinese (Traditional, Hong Kong SAR China)
zh_hant_moChinese (Traditional, Macau SAR China)
zh_hant_twChinese (Traditional, Taiwan)
zuZulu
zu_zaZulu (South Africa)