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.
Locale |
Language |
---|---|
|
Afrikaans |
|
Afrikaans (Namibia) |
|
Afrikaans (South Africa) |
|
Aghem |
|
Aghem (Cameroon) |
|
Akan |
|
Akan (Ghana) |
|
Amharic |
|
Amharic (Ethiopia) |
|
Arabic |
|
Arabic (World) |
|
Arabic (United Arab Emirates) |
|
Arabic (Bahrain) |
|
Arabic (Djibouti) |
|
Arabic (Algeria) |
|
Arabic (Egypt) |
|
Arabic (Western Sahara) |
|
Arabic (Eritrea) |
|
Arabic (Israel) |
|
Arabic (Iraq) |
|
Arabic (Jordan) |
|
Arabic (Comoros) |
|
Arabic (Kuwait) |
|
Arabic (Lebanon) |
|
Arabic (Libya) |
|
Arabic (Morocco) |
|
Arabic (Mauritania) |
|
Arabic (Oman) |
|
Arabic (Palestinian Territories) |
|
Arabic (Qatar) |
|
Arabic (Saudi Arabia) |
|
Arabic (Sudan) |
|
Arabic (Somalia) |
|
Arabic (South Sudan) |
|
Arabic (Syria) |
|
Arabic (Chad) |
|
Arabic (Tunisia) |
|
Arabic (Yemen) |
|
Assamese |
|
Assamese (India) |
|
Asu |
|
Asu (Tanzania) |
|
Asturian |
|
Asturian (Spain) |
|
Azerbaijani |
|
Azerbaijani (Cyrillic) |
|
Azerbaijani (Cyrillic, Azerbaijan) |
|
Azerbaijani (Latin) |
|
Azerbaijani (Latin, Azerbaijan) |
|
Basaa |
|
Basaa (Cameroon) |
|
Belarusian |
|
Belarusian (Belarus) |
|
Bemba |
|
Bemba (Zambia) |
|
Bena |
|
Bena (Tanzania) |
|
Bulgarian |
|
Bulgarian (Bulgaria) |
|
Bambara |
|
Bambara (Mali) |
|
Bangla |
|
Bangla (Bangladesh) |
|
Bangla (India) |
|
Tibetan |
|
Tibetan (China) |
|
Tibetan (India) |
|
Breton |
|
Breton (France) |
|
Bodo |
|
Bodo (India) |
|
Bosnian |
|
Bosnian (Cyrillic) |
|
Bosnian (Cyrillic, Bosnia & Herzegovina) |
|
Bosnian (Latin) |
|
Bosnian (Latin, Bosnia & Herzegovina) |
|
Catalan |
|
Catalan (Andorra) |
|
Catalan (Spain) |
|
Catalan (France) |
|
Catalan (Italy) |
|
Chakma |
|
Chakma (Bangladesh) |
|
Chakma (India) |
|
Chechen |
|
Chechen (Russia) |
|
Chiga |
|
Chiga (Uganda) |
|
Cherokee |
|
Cherokee (United States) |
|
Central Kurdish |
|
Central Kurdish (Iraq) |
|
Central Kurdish (Iran) |
|
Czech |
|
Czech (Czechia) |
|
Welsh |
|
Welsh (United Kingdom) |
|
Danish |
|
Danish (Denmark) |
|
Danish (Greenland) |
|
Taita |
|
Taita (Kenya) |
|
German |
|
German (Austria) |
|
German (Belgium) |
|
German (Switzerland) |
|
German (Germany) |
|
German (Italy) |
|
German (Liechtenstein) |
|
German (Luxembourg) |
|
Zarma |
|
Zarma (Niger) |
|
Lower Sorbian |
|
Lower Sorbian (Germany) |
|
Duala |
|
Duala (Cameroon) |
|
Jola-Fonyi |
|
Jola-Fonyi (Senegal) |
|
Dzongkha |
|
Dzongkha (Bhutan) |
|
Embu |
|
Embu (Kenya) |
|
Ewe |
|
Ewe (Ghana) |
|
Ewe (Togo) |
|
Greek |
|
Greek (Cyprus) |
|
Greek (Greece) |
|
English |
|
English (World) |
|
English (Europe) |
|
English (Antigua & Barbuda) |
|
English (Anguilla) |
|
English (American Samoa) |
|
English (Austria) |
|
English (Australia) |
|
English (Barbados) |
|
English (Belgium) |
|
English (Burundi) |
|
English (Bermuda) |
|
English (Bahamas) |
|
English (Botswana) |
|
English (Belize) |
|
English (Canada) |
|
English (Cocos [Keeling] Islands) |
|
English (Switzerland) |
|
English (Cook Islands) |
|
English (Cameroon) |
|
English (Christmas Island) |
|
English (Cyprus) |
|
English (Germany) |
|
English (Diego Garcia) |
|
English (Denmark) |
|
English (Dominica) |
|
English (Eritrea) |
|
English (Finland) |
|
English (Fiji) |
|
English (Falkland Islands) |
|
English (Micronesia) |
|
English (United Kingdom) |
|
English (Grenada) |
|
English (Guernsey) |
|
English (Ghana) |
|
English (Gibraltar) |
|
English (Gambia) |
|
English (Guam) |
|
English (Guyana) |
|
English (Hong Kong SAR China) |
|
English (Ireland) |
|
English (Israel) |
|
English (Isle of Man) |
|
English (India) |
|
English (British Indian Ocean Territory) |
|
English (Jersey) |
|
English (Jamaica) |
|
English (Kenya) |
|
English (Kiribati) |
|
English (St. Kitts & Nevis) |
|
English (Cayman Islands) |
|
English (St. Lucia) |
|
English (Liberia) |
|
English (Lesotho) |
|
English (Madagascar) |
|
English (Marshall Islands) |
|
English (Macau SAR China) |
|
English (Northern Mariana Islands) |
|
English (Montserrat) |
|
English (Malta) |
|
English (Mauritius) |
|
English (Malawi) |
|
English (Malaysia) |
|
English (Namibia) |
|
English (Norfolk Island) |
|
English (Nigeria) |
|
English (Netherlands) |
|
English (Nauru) |
|
English (Niue) |
|
English (New Zealand) |
|
English (Papua New Guinea) |
|
English (Philippines) |
|
English (Pakistan) |
|
English (Pitcairn Islands) |
|
English (Puerto Rico) |
|
English (Palau) |
|
English (Rwanda) |
|
English (Solomon Islands) |
|
English (Seychelles) |
|
English (Sudan) |
|
English (Sweden) |
|
English (Singapore) |
|
English (St. Helena) |
|
English (Slovenia) |
|
English (Sierra Leone) |
|
English (South Sudan) |
|
English (Sint Maarten) |
|
English (Swaziland) |
|
English (Turks & Caicos Islands) |
|
English (Tokelau) |
|
English (Tonga) |
|
English (Trinidad & Tobago) |
|
English (Tuvalu) |
|
English (Tanzania) |
|
English (Uganda) |
|
English (U.S. Outlying Islands) |
|
English (United States) |
|
English (United States, Computer) |
|
English (St. Vincent & Grenadines) |
|
English (British Virgin Islands) |
|
English (U.S. Virgin Islands) |
|
English (Vanuatu) |
|
English (Samoa) |
|
English (South Africa) |
|
English (Zambia) |
|
English (Zimbabwe) |
|
Esperanto |
|
Spanish |
|
Spanish (Latin America) |
|
Spanish (Argentina) |
|
Spanish (Bolivia) |
|
Spanish (Brazil) |
|
Spanish (Belize) |
|
Spanish (Chile) |
|
Spanish (Colombia) |
|
Spanish (Costa Rica) |
|
Spanish (Cuba) |
|
Spanish (Dominican Republic) |
|
Spanish (Ceuta & Melilla) |
|
Spanish (Ecuador) |
|
Spanish (Spain) |
|
Spanish (Equatorial Guinea) |
|
Spanish (Guatemala) |
|
Spanish (Honduras) |
|
Spanish (Canary Islands) |
|
Spanish (Mexico) |
|
Spanish (Nicaragua) |
|
Spanish (Panama) |
|
Spanish (Peru) |
|
Spanish (Philippines) |
|
Spanish (Puerto Rico) |
|
Spanish (Paraguay) |
|
Spanish (El Salvador) |
|
Spanish (United States) |
|
Spanish (Uruguay) |
|
Spanish (Venezuela) |
|
Estonian |
|
Estonian (Estonia) |
|
Basque |
|
Basque (Spain) |
|
Ewondo |
|
Ewondo (Cameroon) |
|
Persian |
|
Persian (Afghanistan) |
|
Persian (Iran) |
|
Fulah |
|
Fulah (Cameroon) |
|
Fulah (Guinea) |
|
Fulah (Mauritania) |
|
Fulah (Senegal) |
|
Finnish |
|
Finnish (Finland) |
|
Filipino |
|
Filipino (Philippines) |
|
Faroese |
|
Faroese (Denmark) |
|
Faroese (Faroe Islands) |
|
French |
|
French (Belgium) |
|
French (Burkina Faso) |
|
French (Burundi) |
|
French (Benin) |
|
French (St. BarthΓ©lemy) |
|
French (Canada) |
|
French (Congo - Kinshasa) |
|
French (Central African Republic) |
|
French (Congo - Brazzaville) |
|
French (Switzerland) |
|
French (CΓ΄te dβIvoire) |
|
French (Cameroon) |
|
French (Djibouti) |
|
French (Algeria) |
|
French (France) |
|
French (Gabon) |
|
French (French Guiana) |
|
French (Guinea) |
|
French (Guadeloupe) |
|
French (Equatorial Guinea) |
|
French (Haiti) |
|
French (Comoros) |
|
French (Luxembourg) |
|
French (Morocco) |
|
French (Monaco) |
|
French (St. Martin) |
|
French (Madagascar) |
|
French (Mali) |
|
French (Martinique) |
|
French (Mauritania) |
|
French (Mauritius) |
|
French (New Caledonia) |
|
French (Niger) |
|
French (French Polynesia) |
|
French (St. Pierre & Miquelon) |
|
French (RΓ©union) |
|
French (Rwanda) |
|
French (Seychelles) |
|
French (Senegal) |
|
French (Syria) |
|
French (Chad) |
|
French (Togo) |
|
French (Tunisia) |
|
French (Vanuatu) |
|
French (Wallis & Futuna) |
|
French (Mayotte) |
|
Friulian |
|
Friulian (Italy) |
|
Western Frisian |
|
Western Frisian (Netherlands) |
|
Irish |
|
Irish (Ireland) |
|
Scottish Gaelic |
|
Scottish Gaelic (United Kingdom) |
|
Galician |
|
Galician (Spain) |
|
Swiss German |
|
Swiss German (Switzerland) |
|
Swiss German (France) |
|
Swiss German (Liechtenstein) |
|
Gujarati |
|
Gujarati (India) |
|
Gusii |
|
Gusii (Kenya) |
|
Manx |
|
Manx (Isle of Man) |
|
Hausa |
|
Hausa (Ghana) |
|
Hausa (Niger) |
|
Hausa (Nigeria) |
|
Hawaiian |
|
Hawaiian (United States) |
|
Hebrew |
|
Hebrew (Israel) |
|
Hindi |
|
Hindi (India) |
|
Croatian |
|
Croatian (Bosnia & Herzegovina) |
|
Croatian (Croatia) |
|
Upper Sorbian |
|
Upper Sorbian (Germany) |
|
Hungarian |
|
Hungarian (Hungary) |
|
Armenian |
|
Armenian (Armenia) |
|
Indonesian |
|
Indonesian (Indonesia) |
|
Igbo |
|
Igbo (Nigeria) |
|
Sichuan Yi |
|
Sichuan Yi (China) |
|
Icelandic |
|
Icelandic (Iceland) |
|
Italian |
|
Italian (Switzerland) |
|
Italian (Italy) |
|
Italian (San Marino) |
|
Italian (Vatican City) |
|
Japanese |
|
Japanese (Japan) |
|
Ngomba |
|
Ngomba (Cameroon) |
|
Machame |
|
Machame (Tanzania) |
|
Georgian |
|
Georgian (Georgia) |
|
Kabyle |
|
Kabyle (Algeria) |
|
Kamba |
|
Kamba (Kenya) |
|
Makonde |
|
Makonde (Tanzania) |
|
Kabuverdianu |
|
Kabuverdianu (Cape Verde) |
|
Koyra Chiini |
|
Koyra Chiini (Mali) |
|
Kikuyu |
|
Kikuyu (Kenya) |
|
Kazakh |
|
Kazakh (Kazakhstan) |
|
Kako |
|
Kako (Cameroon) |
|
Kalaallisut |
|
Kalaallisut (Greenland) |
|
Kalenjin |
|
Kalenjin (Kenya) |
|
Khmer |
|
Khmer (Cambodia) |
|
Kannada |
|
Kannada (India) |
|
Korean |
|
Korean (North Korea) |
|
Korean (South Korea) |
|
Konkani |
|
Konkani (India) |
|
Kashmiri |
|
Kashmiri (India) |
|
Shambala |
|
Shambala (Tanzania) |
|
Bafia |
|
Bafia (Cameroon) |
|
Colognian |
|
Colognian (Germany) |
|
Cornish |
|
Cornish (United Kingdom) |
|
Kyrgyz |
|
Kyrgyz (Kyrgyzstan) |
|
Langi |
|
Langi (Tanzania) |
|
Luxembourgish |
|
Luxembourgish (Luxembourg) |
|
Ganda |
|
Ganda (Uganda) |
|
Lakota |
|
Lakota (United States) |
|
Lingala |
|
Lingala (Angola) |
|
Lingala (Congo - Kinshasa) |
|
Lingala (Central African Republic) |
|
Lingala (Congo - Brazzaville) |
|
Lao |
|
Lao (Laos) |
|
Northern Luri |
|
Northern Luri (Iraq) |
|
Northern Luri (Iran) |
|
Lithuanian |
|
Lithuanian (Lithuania) |
|
Luba-Katanga |
|
Luba-Katanga (Congo - Kinshasa) |
|
Luo |
|
Luo (Kenya) |
|
Luyia |
|
Luyia (Kenya) |
|
Latvian |
|
Latvian (Latvia) |
|
Masai |
|
Masai (Kenya) |
|
Masai (Tanzania) |
|
Meru |
|
Meru (Kenya) |
|
Morisyen |
|
Morisyen (Mauritius) |
|
Malagasy |
|
Malagasy (Madagascar) |
|
Makhuwa-Meetto |
|
Makhuwa-Meetto (Mozambique) |
|
MetaΚΌ |
|
MetaΚΌ (Cameroon) |
|
Macedonian |
|
Macedonian (Macedonia) |
|
Malayalam |
|
Malayalam (India) |
|
Mongolian |
|
Mongolian (Mongolia) |
|
Marathi |
|
Marathi (India) |
|
Malay |
|
Malay (Brunei) |
|
Malay (Malaysia) |
|
Malay (Singapore) |
|
Maltese |
|
Maltese (Malta) |
|
Mundang |
|
Mundang (Cameroon) |
|
Burmese |
|
Burmese (Myanmar [Burma]) |
|
Mazanderani |
|
Mazanderani (Iran) |
|
Nama |
|
Nama (Namibia) |
|
Norwegian BokmΓ₯l |
|
Norwegian BokmΓ₯l (Norway) |
|
Norwegian BokmΓ₯l (Svalbard & Jan Mayen) |
|
North Ndebele |
|
North Ndebele (Zimbabwe) |
|
Low German |
|
Low German (Germany) |
|
Low German (Netherlands) |
|
Nepali |
|
Nepali (India) |
|
Nepali (Nepal) |
|
Dutch |
|
Dutch (Aruba) |
|
Dutch (Belgium) |
|
Dutch (Caribbean Netherlands) |
|
Dutch (Curaçao) |
|
Dutch (Netherlands) |
|
Dutch (Suriname) |
|
Dutch (Sint Maarten) |
|
Kwasio |
|
Kwasio (Cameroon) |
|
Norwegian Nynorsk |
|
Norwegian Nynorsk (Norway) |
|
Ngiemboon |
|
Ngiemboon (Cameroon) |
|
Nuer |
|
Nuer (South Sudan) |
|
Nyankole |
|
Nyankole (Uganda) |
|
Oromo |
|
Oromo (Ethiopia) |
|
Oromo (Kenya) |
|
Odia |
|
Odia (India) |
|
Ossetic |
|
Ossetic (Georgia) |
|
Ossetic (Russia) |
|
Punjabi |
|
Punjabi (Arabic) |
|
Punjabi (Arabic, Pakistan) |
|
Punjabi (Gurmukhi) |
|
Punjabi (Gurmukhi, India) |
|
Polish |
|
Polish (Poland) |
|
Pashto |
|
Pashto (Afghanistan) |
|
Portuguese |
|
Portuguese (Angola) |
|
Portuguese (Brazil) |
|
Portuguese (Switzerland) |
|
Portuguese (Cape Verde) |
|
Portuguese (Equatorial Guinea) |
|
Portuguese (Guinea-Bissau) |
|
Portuguese (Luxembourg) |
|
Portuguese (Macau SAR China) |
|
Portuguese (Mozambique) |
|
Portuguese (Portugal) |
|
Portuguese (SΓ£o TomΓ© & PrΓncipe) |
|
Portuguese (Timor-Leste) |
|
Quechua |
|
Quechua (Bolivia) |
|
Quechua (Ecuador) |
|
Quechua (Peru) |
|
Romansh |
|
Romansh (Switzerland) |
|
Rundi |
|
Rundi (Burundi) |
|
Romanian |
|
Romanian (Moldova) |
|
Romanian (Romania) |
|
Rombo |
|
Rombo (Tanzania) |
|
Russian |
|
Russian (Belarus) |
|
Russian (Kyrgyzstan) |
|
Russian (Kazakhstan) |
|
Russian (Moldova) |
|
Russian (Russia) |
|
Russian (Ukraine) |
|
Kinyarwanda |
|
Kinyarwanda (Rwanda) |
|
Rwa |
|
Rwa (Tanzania) |
|
Sakha |
|
Sakha (Russia) |
|
Samburu |
|
Samburu (Kenya) |
|
Sangu |
|
Sangu (Tanzania) |
|
Northern Sami |
|
Northern Sami (Finland) |
|
Northern Sami (Norway) |
|
Northern Sami (Sweden) |
|
Sena |
|
Sena (Mozambique) |
|
Koyraboro Senni |
|
Koyraboro Senni (Mali) |
|
Sango |
|
Sango (Central African Republic) |
|
Tachelhit |
|
Tachelhit (Latin) |
|
Tachelhit (Latin, Morocco) |
|
Tachelhit (Tifinagh) |
|
Tachelhit (Tifinagh, Morocco) |
|
Sinhala |
|
Sinhala (Sri Lanka) |
|
Slovak |
|
Slovak (Slovakia) |
|
Slovenian |
|
Slovenian (Slovenia) |
|
Inari Sami |
|
Inari Sami (Finland) |
|
Shona |
|
Shona (Zimbabwe) |
|
Somali |
|
Somali (Djibouti) |
|
Somali (Ethiopia) |
|
Somali (Kenya) |
|
Somali (Somalia) |
|
Albanian |
|
Albanian (Albania) |
|
Albanian (Macedonia) |
|
Albanian (Kosovo) |
|
Serbian |
|
Serbian (Cyrillic) |
|
Serbian (Cyrillic, Bosnia & Herzegovina) |
|
Serbian (Cyrillic, Montenegro) |
|
Serbian (Cyrillic, Serbia) |
|
Serbian (Cyrillic, Kosovo) |
|
Serbian (Latin) |
|
Serbian (Latin, Bosnia & Herzegovina) |
|
Serbian (Latin, Montenegro) |
|
Serbian (Latin, Serbia) |
|
Serbian (Latin, Kosovo) |
|
Swedish |
|
Swedish (Γ land Islands) |
|
Swedish (Finland) |
|
Swedish (Sweden) |
|
Swahili |
|
Swahili (Congo - Kinshasa) |
|
Swahili (Kenya) |
|
Swahili (Tanzania) |
|
Swahili (Uganda) |
|
Tamil |
|
Tamil (India) |
|
Tamil (Sri Lanka) |
|
Tamil (Malaysia) |
|
Tamil (Singapore) |
|
Telugu |
|
Telugu (India) |
|
Teso |
|
Teso (Kenya) |
|
Teso (Uganda) |
|
Tajik |
|
Tajik (Tajikistan) |
|
Thai |
|
Thai (Thailand) |
|
Tigrinya |
|
Tigrinya (Eritrea) |
|
Tigrinya (Ethiopia) |
|
Tongan |
|
Tongan (Tonga) |
|
Turkish |
|
Turkish (Cyprus) |
|
Turkish (Turkey) |
|
Tatar |
|
Tatar (Russia) |
|
Tasawaq |
|
Tasawaq (Niger) |
|
Central Atlas Tamazight |
|
Central Atlas Tamazight (Morocco) |
|
Uyghur |
|
Uyghur (China) |
|
Ukrainian |
|
Ukrainian (Ukraine) |
|
Urdu |
|
Urdu (India) |
|
Urdu (Pakistan) |
|
Uzbek |
|
Uzbek (Arabic) |
|
Uzbek (Arabic, Afghanistan) |
|
Uzbek (Cyrillic) |
|
Uzbek (Cyrillic, Uzbekistan) |
|
Uzbek (Latin) |
|
Uzbek (Latin, Uzbekistan) |
|
Vai |
|
Vai (Latin) |
|
Vai (Latin, Liberia) |
|
Vai (Vai) |
|
Vai (Vai, Liberia) |
|
Vietnamese |
|
Vietnamese (Vietnam) |
|
Vunjo |
|
Vunjo (Tanzania) |
|
Walser |
|
Walser (Switzerland) |
|
Wolof |
|
Wolof (Senegal) |
|
Soga |
|
Soga (Uganda) |
|
Yangben |
|
Yangben (Cameroon) |
|
Yiddish |
|
Yiddish (World) |
|
Yoruba |
|
Yoruba (Benin) |
|
Yoruba (Nigeria) |
|
Cantonese |
|
Cantonese (Simplified) |
|
Cantonese (Simplified, China) |
|
Cantonese (Traditional) |
|
Cantonese (Traditional, Hong Kong SAR China) |
|
Standard Moroccan Tamazight |
|
Standard Moroccan Tamazight (Morocco) |
|
Chinese |
|
Chinese (Simplified) |
|
Chinese (Simplified, China) |
|
Chinese (Simplified, Hong Kong SAR China) |
|
Chinese (Simplified, Macau SAR China) |
|
Chinese (Simplified, Singapore) |
|
Chinese (Traditional) |
|
Chinese (Traditional, Hong Kong SAR China) |
|
Chinese (Traditional, Macau SAR China) |
|
Chinese (Traditional, Taiwan) |
|
Zulu |
|
Zulu (South Africa) |