Default Collations in MS SQL Server Setup
http://msdn2.microsoft.com/en-us/library/ms143508.aspx
Default Collations in SQL Server Setup
In Control Panel, find the Microsoft Windows locale name in Regional Options in (Windows 2000)
or Regional and Language Options (Windows XP), and then use the following table to
find the corresponding collation designator and code page to match collation settings with
an existing Windows locale in the table of SQL Server 2005 collations below.
Windows System Locale LCID (Locale ID) Default SQL Collation Code page
Afrikaans 0x436 Latin1_General_CI_AS 1252
Albanian 0x41c Albanian_CI_AS 1250
Arabic (Algeria) 0x1401 Arabic_CI_AS 1256
Arabic (Bahrain) 0x3c01 Arabic_CI_AS 1256
Arabic (Egypt) 0xc01 Arabic_CI_AS 1256
Arabic (Iraq) 0x801 Arabic_CI_AS 1256
Arabic (Jordan) 0x2c01 Arabic_CI_AS 1256
Arabic (Kuwait) 0x3401 Arabic_CI_AS 1256
Arabic (Lebanon) 0x3001 Arabic_CI_AS 1256
Arabic (Libya) 0x1001 Arabic_CI_AS 1256
Arabic (Morocco) 0x1801 Arabic_CI_AS 1256
Arabic (Oman) 0x2001 Arabic_CI_AS 1256
Arabic (Qatar) 0x4001 Arabic_CI_AS 1256
Arabic (Saudi Arabia) 0x401 Arabic_CI_AS 1256
Arabic (Syria) 0x2801 Arabic_CI_AS 1256
Arabic (Tunisia) 0x1c01 Arabic_CI_AS 1256
Arabic (U.A.E.) 0x3801 Arabic_CI_AS 1256
Arabic (Yemen) 0x2401 Arabic_CI_AS 1256
Armenian (Republic of Armenia) 0x42b Latin1_General_CI_AS Unicode
Azeri-Cyrillic (Azerbaijan)1 0x82c Azeri_Cyrillic_90_CI_AS 1251
1
Azeri-Latin (Azerbaijan) 0x42c Azeri_Latin_90_CI_AS 1254
Basque 0x42d Latin1_General_CI_AS 1252
Belarusian 0x423 Cyrillic_General_CI_AS 1251
Bulgarian 0x402 Cyrillic_General_CI_AS 1251
Catalan 0x403 Latin1_General_CI_AS 1252
Chinese (Hong Kong S.A.R.)1 0xc04 Chinese_Hong_Kong_Stroke_90_CI_AS 950
Chinese (Macau S.A.R.)2 0x1404 Chinese_PRC_90_CI_AS 950
2
Chinese (PRC) 0x804 Chinese_PRC_CI_AS 936
Chinese (PRC) 0x20804 Chinese_PRC_Stroke_CI_AS 936
Chinese (Singapore) 0x1004 Chinese_PRC_90_CI_AS 936
Chinese (Taiwan) 0x404 Chinese_Taiwan_Stroke_CI_AS 950
Chinese (Taiwan) 0x30404 Chinese_Taiwan_Bopomofo_CI_AS 950
Croatian 0x41a Croatian_CI_AS 1250
Czech 0x405 Czech_CI_AS 1250
Danish 0x406 Danish_Norwegian_CI_AS 1252
1
Divehi 0x465 Divehi_90_CI_AS (Unicode only) Unicode
Dutch (Belgium) 0x813 Latin1_General_CI_AS 1252
Dutch (Netherlands) 0x413 Latin1_General_CI_AS 1252
English (Australia) 0xc09 Latin1_General_CI_AS 1252
English (Belize) 0x2809 Latin1_General_CI_AS 1252
English (Canada) 0x1009 Latin1_General_CI_AS 1252
English (Caribbean) 0x2409 Latin1_General_CI_AS 1252
English (Hong Kong S.A.R.) 0x3c09 Latin1_General_CI_AS 1252
English (India) 0x4009 Latin1_General_CI_AS 1252
English (Indonesia) 0x3809 Latin1_General_CI_AS 1252
English (Ireland) 0x1809 Latin1_General_CI_AS 1252
English (Jamaica) 0x2009 Latin1_General_CI_AS 1252
English (Malaysia) 0x4409 Latin1_General_CI_AS 1252
English (New Zealand) 0x1409 Latin1_General_CI_AS 1252
English (Philippines) 0x3409 Latin1_General_CI_AS 1252
English (Singapore) 0x4809 Latin1_General_CI_AS 1252
English (South Africa) 0x1c09 Latin1_General_CI_AS 1252
English (Trinidad) 0x2c09 Latin1_General_CI_AS 1252
English (United Kingdom) 0x809 Latin1_General_CI_AS 1252
English (United States) 0x409 SQL_Latin1_General_CP1_CI_AS 1252
English (Zimbabwe) 0x3009 Latin1_General_CI_AS 1252
Estonian 0x425 Estonian_CI_AS 1257
Faeroese 0x438 Latin1_General_CI_AS 1252
Farsi 0x429 Arabic_CI_AS 1256
Finnish 0x40b Finnish_Swedish_CI_AS 1252
French (Belgium) 0x80c French_CI_AS 1252
French (Canada) 0xc0c French_CI_AS 1252
French (France) 0x40c French_CI_AS 1252
French (Luxembourg) 0x140c French_CI_AS 1252
French (Monaco) 0x180c French_CI_AS 1252
French (Switzerland) 0x100c French_CI_AS 1252
Galician (Spain) 0x456 Latin1_General_CI_AS 1252
Georgian 0x437 Latin1_General_CI_AS Unicode
German (Austria) 0xc07 Latin1_General_CI_AS 1252
German (Germany) 0x407 Latin1_General_CI_AS 1252
German (Liechtenstein) 0x1407 Latin1_General_CI_AS 1252
German (Luxembourg) 0x1007 Latin1_General_CI_AS 1252
German (Phone Book Sort) 0x10407 German_PhoneBook_CI_AS 1252
German (Switzerland) 0x807 Latin1_General_CI_AS 1252
Greek 0x408 Greek_CI_AS 1253
Gujarati (India)3 0x447 Indic_General_90_CI_AS (Unicode only) Unicode
Hebrew 0x40d Hebrew_CI_AS 1255
Hindi3 0x0439 Indic_General_90_CI_AS (Unicode only) Unicode
Hungarian 0x40e Hungarian_CI_AS 1250
Hungarian (Technical) 0x104e Hungarian_Technical_CI_AS 1250
Icelandic 0x40f Icelandic_CI_AS 1252
Indonesian 0x421 Latin1_General_CI_AS 1252
Italian (Italy) 0x410 Latin1_General_CI_AS 1252
Italian (Switzerland) 0x810 Latin1_General_CI_AS 1252
Japanese 0x411 Japanese_CI_AS 932
Japanese (Unicode) 0x10411 Japanese_Unicode_CI_AS 932
3
Kannada (India) 0x44b Indic_General_90_CI_AS (Unicode only) Unicode
Kazakh (Kazakstan)1 0x43f Kazakh_90_CI_AS 1251
3
Konkani (India) 0x457 Indic_General_90_CI_AS (Unicode only) Unicode
Korean (Extended Wansung) 0x0412 Korean_Wansung_CI_AS 949
Kyrgyz-Cyrillic (Republic of Kyrgyztan) 0x440 Cyrillic_General_CI_AS 1251
Latvian 0x426 Latvian_CI_AS 1257
Lithuanian 0x427 Lithuanian_CI_AS 1257
Macedonian (FYROM) 0x42f Macedonian_FYROM_90_CI_AS 1251
Malay (Brunei Darussalam) 0x83e Latin1_General_CI_AS 1252
Malay (Malaysia) 0x43e Latin1_General_CI_AS 1252
Marathi (India)3 0x44e Indic_General_90_CI_AS (Unicode only) Unicode
Mongolian-Cyrillic (Mongolia) 0x450 Cyrillic_General_CI_AS 1251
Norwegian (Bokmal) 0x414 Danish_Norwegian_CI_AS 1252
Norwegian (Nynorsk) 0x814 Danish_Norwegian_CI_AS 1252
Polish 0x415 Polish_CI_AS 1250
Portuguese (Brazil) 0x416 Latin1_General_CI_AS 1252
Portuguese (Portugal) 0x816 Latin1_General_CI_AS 1252
3
Punjab-Gurmuhki (India) 0x446 Indic_General_90_CI_AS (Unicode only) Unicode
Romanian 0x418 Romanian_CI_AS 1250
Russian 0x419 Cyrillic_General_CI_AS 1251
Sanskrit (India)3 0x44f Indic_General_90_CI_AS (Unicode only) Unicode
Serbian (Cyrillic) 0xc1a Cyrillic_General_CI_AS 1251
Serbian (Latin) 0x81a Cyrillic_General_CI_AS 1250
Slovak 0x41b Slovak_CI_AS 1250
Slovenian 0x424 Slovenian_CI_AS 1250
Spanish (Argentina) 0x2c0a Modern_Spanish_CI_AS 1252
Spanish (Bolivia) 0x400a Modern_Spanish_CI_AS 1252
Spanish (Chile) 0x340a Modern_Spanish_CI_AS 1252
Spanish (Colombia) 0x240a Modern_Spanish_CI_AS 1252
Spanish (Costa Rica) 0x140a Modern_Spanish_CI_AS 1252
Spanish (Dominican Republic) 0x1c0a Modern_Spanish_CI_AS 1252
Spanish (Ecuador) 0x300a Modern_Spanish_CI_AS 1252
Spanish (El Salvador) 0x440a Modern_Spanish_CI_AS 1252
Spanish (Guatemala) 0x100a Modern_Spanish_CI_AS 1252
Spanish (Honduras) 0x480a Modern_Spanish_CI_AS 1252
Spanish (International Sort) 0xc0a Modern_Spanish_CI_AS 1252
Spanish (Mexico) 0x80a Modern_Spanish_CI_AS 1252
Spanish (Nicaragua) 0x4c0a Modern_Spanish_CI_AS 1252
Spanish (Panama) 0x180a Modern_Spanish_CI_AS 1252
Spanish (Paraguay) 0x3c0a Modern_Spanish_CI_AS 1252
Spanish (Peru) 0x280a Modern_Spanish_CI_AS 1252
Spanish (Puerto Rico) 0x500a Modern_Spanish_CI_AS 1252
Spanish (Traditional Sort) 0x40a Traditional_Spanish_CI_AS 1252
Spanish (Uruguay) 0x380a Modern_Spanish_CI_AS 1252
Spanish (Venezuela) 0x200a Modern_Spanish_CI_AS 1252
Swahili 0x441 Latin1_General_CI_AS 1252
Swedish 0x41d Finnish_Swedish_CI_AS 1252
Swedish (Finland) 0x81d Finnish_Swedish_CI_AS 1252
1
Syriac (Syria) 0x45a Syriac_90_CI_AS (Unicode only) Unicode
Tamil (India)1 0x449 Indic_General_90_CI_AS (Unicode only) Unicode
1
Tatar (Tatarstan) 0x444 Tatar_90_CI_AS 1251
Telugu (India)1 0x44a Indic_General_90_CI_AS (Unicode only) Unicode
Thai 0x41e Thai_CI_AS 874
Turkish 0x41f Turkish_CI_AS 1254
Ukrainian 0x422 Ukrainian_CI_AS 1251
Urdu 0x420 Arabic_CI_AS 1256
1
Uzbek (Latin) 0x443 Uzbek_Latin_90_CI_AS 1254
Uzbek-Cyrillic (Republic of Uzbeckistan) 0x843 Cyrillic_General_CI_AS 1251
Vietnamese 0x42a Vietnamese_CI_AS 1258
1
New collations for SQL Server 2005; these collations use the Windows 2003 sorting tables and,
therefore, support supplementary characters. Both BIN and BIN2 binary sorts are supported for the
new 90 Windows collations.
2
Use Pingyin or Pronunciation for sorting.
3
Major change to sorting behavior; use the new default collation, Indic_General_90_CI_AS (Unicode
only).
4
The Hindi collation is deprecated in SQL Server 2005 because the Windows 2000 sorting table is
used in this SQL Server release. The collation still exists in the server, but it will not be supported in
a future SQL Server release, and it does not show up in ::fn_helpcollations().
5
The Hindi and Lithuanian_Classic collations are deprecated in SQL Server 2005. These collations
still exist in the server, but they will not be supported in a future SQL Server release, and they do
not show up in ::fn_helpcollations().
