Windows Collation Name (Transact-SQL)
Specifies the Windows collation name in the COLLATE clause. The Windows collationsName is composed of the collation designator and the comparison styles.
The following are some examples of Windows collationNames:
Latin1_General_100_
Collation uses the Latin1 General dictionary sorting rules, code page 1252. Is case-insensitive and accent-sensitive. Collation uses the Latin1 General dictionary sorting rules and maps to code page 1252. Shows the version number of the collation if it is a Windows collation offered in SQL Server 2000 and later: No version number for SQL Server 2000, _90 for SQL Server 2005, or _100 for SQL Server 2008. Is case-insensitive (CI), and accent-sensitive (AS).
Estonian_CS_AS
Collation uses the Estonian dictionary sorting rules, code page 1257. Is case-sensitive and accent-sensitive.
Latin1_General_BIN
Collation uses code page 1252 and binary sorting rules. The Latin1 General dictionary sorting rules are ignored.
For a table of Windows locales with their corresponding SQL collation designators, see Collation Settings in Setup.
Current Windows Unicode collations are transitioning to Unicode 5.0-based collations in SQL Server 2008. Future Windows Unicode collations may be based on higher versions of Unicode.
There are many new Windows collations available in SQL Server 2008, as well as new versions of existing Windows collations. The naming convention for Windows collations can include the language, the Windows Locale Name (or a country or region designation within the locale), and the case, accent, and width sensitivity. Windows collations that designate a country or region name in addition to the language name are usually distinct because they have different sort orders than other collations in the same language and map to a different code page.
New Windows Collations
The following table lists the new collations or new versions of Windows collation names that are supported in SQL Server 2008.
Windows locale | New for SQL Server 2008 (100) |
|---|---|
Alsatian (France) | Latin1_General_100_ |
Amharic (Ethiopia) | Latin1_General_100_ |
Armenian (Armenia) | Cyrillic_General_100_ |
Assamese (India) | Assamese_100_1 |
Bashkir (Russia) | Bashkir_100_ |
Basque (Basque) | Latin1_General_100_ |
Bengali (Bangladesh) | Bengali_100_1 |
Bengali (India) | Bengali_100_1 |
Bosnian (Bosnia and Herzegovina, Cyrillic) | Bosnian_Cyrillic_100_ |
Bosnian (Bosnia and Herzegovina, Latin) | Bosnian_Latin_100_ |
Breton (France) | Breton_100_ |
Chinese (Macao SAR) | Chinese_Traditional_Pinyin_100_ |
Chinese (Macau) | Chinese_Traditional_Stroke_Order_100_ |
Chinese (Singapore) | Chinese_Simplified_Stroke_Order_100_ |
Corsican (France) | Corsican_100_ |
Croatian (Bosnia and Herzegovina, Latin) | Croatian_100_ |
Dari (Afghanistan) | Dari_100_ |
English (India) | Latin1_General_100_ |
English (Malaysia) | Latin1_General_100_ |
English (Singapore) | Latin1_General_100_ |
Filipino (Philippines) | Latin1_General_100_ |
Frisian (Netherlands) | Frisian_100_ |
Georgian (Georgia) | Cyrillic_General_100_ |
Greenlandic (Greenland) | Danish_Greenlandic_100_ |
Hausa (Nigeria, Latin) | Latin1_General_100_ |
Igbo (Nigeria) | Latin1_General_100_ |
Inuktitut (Canada, Latin) | Latin1_General_100_ |
Inuktitut (Syllabics) Canada | Latin1_General_100_ |
Irish (Ireland) | Latin1_General_100_ |
Japanese (Japan) | Japanese_Bushu_Kakusu_100_ |
Khmer (Cambodia) | Khmer_100_1 |
K'iche (Guatemala) | Modern_Spanish_100_ |
Kinyarwanda (Rwanda) | Latin1_General_100_ |
Lao (Lao PDR) | Lao_100_1 |
Lower Sorbian (Germany) | Latin1_General_100_ |
Luxembourgish (Luxembourg) | Latin1_General_100_ |
Malayalam (India) | Indic_General_100_1 |
Maltese (Malta) | Maltese_100_ |
Maori (New Zealand) | Maori_100_ |
Mapudungun (Chile) | Mapudungan_100_ |
Mohawk (Canada) | Mohawk_100_ |
Mongolian (PRC) | Cyrillic_General_100_ |
Nepali (Nepal) | Nepali_100_1 |
Norwegian (Bokmål, Norway) | Norwegian_100_ |
Norwegian (Nynorsk, Norway) | Norwegian_100_ |
Occitan (France) | French_100_ |
Oriya (India) | Indic_General_100_1 |
Pashto (Afghanistan) | Pashto_100_1 |
Persian (Iran) | Persian_100_ |
Quechua (Bolivia) | Latin1_General_100_ |
Quechua (Ecuador) | Latin1_General_100_ |
Quechua (Peru) | Latin1_General_100_ |
Romansh (Switzerland) | Romansh_100_ |
Sami (Inari, Finland) | Sami_Sweden_Finland_100_ |
Sami (Lule, Norway) | Sami_Norway_100_ |
Sami (Lule, Sweden) | Sami_Sweden_Finland_100_ |
Sami (Northern, Finland) | Sami_Sweden_Finland_100_ |
Sami (Northern, Norway) | Sami_Norway_100_ |
Sami (Northern, Sweden) | Sami_Sweden_Finland_100_ |
Sami (Skolt, Finland) | Sami_Sweden_Finland_100_ |
Sami (Southern, Norway) | Sami_Norway_100_ |
Sami (Southern, Sweden) | Sami_Sweden_Finland_100_ |
Serbian (Bosnia and Herzegovina, Cyrillic) | Serbian_Cyrillic_100_ |
Serbian (Bosnia and Herzegovina, Latin) | Serbian_Latin_100_ |
Sesotho sa Leboa/Northern Sotho (South Africa) | Latin1_General_100_ |
Setswana/Tswana (South Africa) | Latin1_General_100_ |
Sinhala (Sri Lanka) | Indic_General_100_1 |
Spanish (United States) | Latin1_General_100_ |
Swahili (Kenya) | Latin1_General_100_ |
Tajik (Tajikistan) | Cyrillic_General_100_ |
Tamazight (Algeria, Latin) | Tamazight_100_ |
Tibetan (PRC) | Tibetan_100_1 |
Turkmen (Turkmenistan) | Turkmen_100_ |
Uighur (PRC) | Uighur_100_ |
Ukrainian (Ukraine) | Ukrainian_100_ |
Upper Sorbian (Germany) | Upper_Sorbian_100_ |
Urdu (Pakistan) | Urdu_100_ |
Welsh (United Kingdom) | Welsh_100_ |
Wolof (Senegal) | French_100_ |
Xhosa/isiXhosa (South Africa) | Latin1_General_100_ |
Yakut (Russia) | Yakut_100_ |
Yi (PRC) | Latin1_General_100_ |
Yoruba (Nigeria) | Latin1_General_100_ |
Zulu/isiZulu (South Africa) | Latin1_General_100_ |
1 Windows Unicode-only collations can only be used with the COLLATE clause to apply collations to the nchar, nvarchar, and ntext data types on column level and expression-level data; they cannot be used with the COLLATE clause to set or change the collation of a database or server instance.
All Windows Collations
The following table lists all Windows collations supported in SQL Server 2008.
Windows locale | SQL Server 2008 (100) | SQL Server 2005 (90) or SQL Server 2000 |
|---|---|---|
Afrikaans (South Africa) | Latin1_General_100_ | Latin1_General_ |
Albanian (Albania) | Albanian_100_ | Albanian_ |
Alsatian (France) | Latin1_General_100_ | New to SQL Server 2008 |
Amharic (Ethiopia) | Latin1_General_100_ | New to SQL Server 2008 |
Arabic (Algeria) | Arabic_100_ | Arabic_ |
Arabic (Bahrain) | Arabic_100_ | Arabic_ |
Arabic (Egypt) | Arabic_100_ | Arabic_ |
Arabic (Iraq) | Arabic_100_ | Arabic_ |
Arabic (Jordan) | Arabic_100_ | Arabic_ |
Arabic (Kuwait) | Arabic_100_ | Arabic_ |
Arabic (Lebanon) | Arabic_100_ | Arabic_ |
Arabic (Libya) | Arabic_100_ | Arabic_ |
Arabic (Morocco) | Arabic_100_ | Arabic_ |
Arabic (Oman) | Arabic_100_ | Arabic_ |
Arabic (Qatar) | Arabic_100_ | Arabic_ |
Arabic (Saudi Arabia) | Arabic_100_ | Arabic_ |
Arabic (Syria) | Arabic_100_ | Arabic_ |
Arabic (Tunisia) | Arabic_100_ | Arabic_ |
Arabic (U.A.E.) | Arabic_100_ | Arabic_ |
Arabic (Yemen) | Arabic_100_ | Arabic_ |
Armenian (Armenia) | Cyrillic_General_100_ | New to SQL Server 2008 |
Assamese (India) | Assamese_100_ 1 | New to SQL Server 2008 |
Azeri (Azerbaijan, Cyrillic) | Azeri_Cyrillic_100_ | Azeri_Cyrillic_90_ |
Azeri (Azerbaijan, Latin) | Azeri_Latin_100_ | Azeri_Latin_90_ |
Bashkir (Russia) | Bashkir_100_ | New to SQL Server 2008 |
Basque (Basque) | Latin1_General_100_ | New to SQL Server 2008 |
Belarusian (Belarus) | Cyrillic_General_100_ | Cyrillic_General_ |
Bengali (Bangladesh) | Bengali_100_1 | New to SQL Server 2008 |
Bengali (India) | Bengali_100_1 | New to SQL Server 2008 |
Bosnian (Bosnia and Herzegovina, Cyrillic) | Bosnian_Cyrillic_100_ | New to SQL Server 2008 |
Bosnian (Bosnia and Herzegovina, Latin) | Bosnian_Latin_100_ | New to SQL Server 2008 |
Breton (France) | Breton_100_ | New to SQL Server 2008 |
Bulgarian (Bulgaria) | Cyrillic_General_100_ | Cyrillic_General_ |
Catalan (Catalan) | Latin1_General_100_ | Latin1_General_ |
Chinese (Hong Kong SAR, PRC) | Chinese_Traditional_Stroke_Count_100_ | Chinese_Hong_Kong_Stroke_90_ |
Chinese (Macao SAR) | Chinese_Traditional_Pinyin_100_ | New to SQL Server 2008 |
Chinese (Macau) | Chinese_Traditional_Stroke_Order_100_ | New to SQL Server 2008 |
Chinese (PRC) | Chinese_Simplified_Pinyin_100_ | Chinese_PRC_90_, Chinese_PRC_ |
Chinese (PRC) | Chinese_Simplified_Stroke_Order_100_ | Chinese_PRC_Stroke_90_, Chinese_PRC_Stroke_ |
Chinese (Singapore) | Chinese_Simplified_Pinyin_100_ | Chinese_PRC_90_, Chinese_PRC_ |
Chinese (Singapore) | Chinese_Simplified_Stroke_Order_100_ | New to SQL Server 2008 |
Chinese (Taiwan) | Chinese_Traditional_Bopomofo_100_ | Chinese_Taiwan_Bopomofo_90_, Chinese_Taiwan_Bopomofo_ |
Chinese (Taiwan) | Chinese_Traditional_Stroke_Count_100_ | Chinese_Taiwan_Stroke_90_, Chinese_Taiwan_Stroke_ |
Corsican (France) | Corsican_100_ | New to SQL Server 2008 |
Croatian (Bosnia and Herzegovina, Latin) | Croatian_100_ | New to SQL Server 2008 |
Croatian (Croatia) | Croatian_100_ | Croatian_ |
Czech (Czech Republic) | Czech_100_ | Czech_ |
Danish (Denmark) | Danish_Greenlandic_100_ | Danish_Norwegian_ |
Dari (Afghanistan) | Dari_100_ | New to SQL Server 2008 |
Divehi (Maldives) | Divehi_100_1 | Divehi_90_ |
Dutch (Belgium) | Latin1_General_100_ | Latin1_General_ |
Dutch (Netherlands) | Latin1_General_100_ | Latin1_General_ |
English (Australia) | Latin1_General_100_ | Latin1_General_ |
English (Belize) | Latin1_General_100_ | Latin1_General_ |
English (Canada) | Latin1_General_100_ | Latin1_General_ |
English (Caribbean) | Latin1_General_100_ | Latin1_General_ |
English (India) | Latin1_General_100_ | New to SQL Server 2008 |
English (Ireland) | Latin1_General_100_ | Latin1_General_ |
English (Jamaica) | Latin1_General_100_ | Latin1_General_ |
English (Malaysia) | Latin1_General_100_ | New to SQL Server 2008 |
English (New Zealand) | Latin1_General_100_ | Latin1_General_ |
English (Philippines) | Latin1_General_100_ | Latin1_General_ |
English (Singapore) | Latin1_General_100_ | New to SQL Server 2008 |
English (South Africa) | Latin1_General_100_ | Latin1_General_ |
English (Trinidad and Tobago) | Latin1_General_100_ | Latin1_General_ |
English (United Kingdom) | Latin1_General_100_ | Latin1_General_ |
English (United States) | SQL_Latin1_General_CP1_ | SQL_Latin1_General_CP1_ |
English (Zimbabwe) | Latin1_General_100_ | Latin1_General_ |
Estonian (Estonia) | Estonian_100_ | Estonian_ |
Faroese (Faroe Islands) | Latin1_General_100_ | Latin1_General_ |
Filipino (Philippines) | Latin1_General_100_ | New to SQL Server 2008 |
Finnish (Finland) | Finnish_Swedish_100_ | Finnish_Swedish_ |
French (Belgium) | French_100_ | French_ |
French (Canada) | French_100_ | French_ |
French (France) | French_100_ | French_ |
French (Luxembourg) | French_100_ | French_ |
French (Monaco) | French_100_ | French_ |
French (Switzerland) | French_100_ | French_ |
Frisian (Netherlands) | Frisian_100_ | New to SQL Server 2008 |
Galician (Spain) | Latin1_General_100_ | Latin1_General_ |
Georgian (Georgia) | Georgian_Modern_Sort_100_ | Georgian_Modern_Sort_ |
Georgian (Georgia) | Cyrillic_General_100_ | New to SQL Server 2008 |
German - Phone Book Sort (DIN) | German_PhoneBook_100_ | German_PhoneBook_ |
German (Austria) | Latin1_General_100_ | Latin1_General_ |
German (Germany) | Latin1_General_100_ | Latin1_General_ |
German (Liechtenstein) | Latin1_General_100_ | Latin1_General_ |
German (Luxembourg) | Latin1_General_100_ | Latin1_General_ |
German (Switzerland) | Latin1_General_100_ | Latin1_General_ |
Greek (Greece) | Greek_100_ | Greek_ |
Greenlandic (Greenland) | Danish_Greenlandic_100_ | New to SQL Server 2008 |
Gujarati (India) | Indic_General_100_1 | Indic_General_90_ |
Hausa (Nigeria, Latin) | Latin1_General_100_ | New to SQL Server 2008 |
Hebrew (Israel) | Hebrew_100_ | Hebrew_ |
Hindi (India) | Indic_General_100_1 | Indic_General_90_ |
Hungarian (Hungary) | Hungarian_100_ | Hungarian_ |
Hungarian Technical Sort | Hungarian_Technical_100_ | Hungarian_Technical_ |
Icelandic (Iceland) | Icelandic_100_ | Icelandic_ |
Igbo (Nigeria) | Latin1_General_100_ | New to SQL Server 2008 |
Indonesian (Indonesia) | Latin1_General_100_ | Latin1_General_ |
Inuktitut (Canada, Latin) | Latin1_General_100_ | New to SQL Server 2008 |
Inuktitut (Syllabics) Canada | Latin1_General_100_ | New to SQL Server 2008 |
Irish (Ireland) | Latin1_General_100_ | New to SQL Server 2008 |
Italian (Italy) | Latin1_General_100_ | Latin1_General_ |
Italian (Switzerland) | Latin1_General_100_ | Latin1_General_ |
Japanese (Japan XJIS) | Japanese_XJIS_100_ | Japanese_90_, Japanese_ |
Japanese (Japan) | Japanese_Bushu_Kakusu_100_ | New to SQL Server 2008 |
Kannada (India) | Indic_General_100_1 | Indic_General_90_ |
Kazakh (Kazakhstan) | Kazakh_100_ | Kazakh_90_ |
Khmer (Cambodia) | Khmer_100_1 | New to SQL Server 2008 |
K'iche (Guatemala) | Modern_Spanish_100_ | New to SQL Server 2008 |
Kinyarwanda (Rwanda) | Latin1_General_100_ | New to SQL Server 2008 |
Konkani (India) | Indic_General_100_1 | Indic_General_90_ |
Korean (Korea Dictionary Sort) | Korean_100_ | Korean_90_, Korean_Wansung_ |
Kyrgyz (Kyrgyzstan) | Cyrillic_General_100_ | Cyrillic_General_ |
Lao (Lao PDR) | Lao_100_1 | New to SQL Server 2008 |
Latvian (Latvia) | Latvian_100_ | Latvian_ |
Lithuanian (Lithuania) | Lithuanian_100_ | Lithuanian_ |
Lower Sorbian (Germany) | Latin1_General_100_ | New to SQL Server 2008 |
Luxembourgish (Luxembourg) | Latin1_General_100_ | New to SQL Server 2008 |
Macedonian (Macedonia, FYROM) | Macedonian_FYROM_100_ | Macedonian_FYROM_90_ |
Malay (Brunei Darussalam) | Latin1_General_100_ | Latin1_General_ |
Malay (Malaysia) | Latin1_General_100_ | Latin1_General_ |
Malayalam (India) | Indic_General_100_1 | New to SQL Server 2008 |
Maltese (Malta) | Maltese_100_ | New to SQL Server 2008 |
Maori (New Zealand) | Maori_100_ | New to SQL Server 2008 |
Mapudungun (Chile) | Mapudungan_100_ | New to SQL Server 2008 |
Marathi (India) | Indic_General_100_1 | Indic_General_90_ |
Mohawk (Canada) | Mohawk_100_ | New to SQL Server 2008 |
Mongolian (Mongolia) | Cyrillic_General_100_ | Cyrillic_General_ |
Mongolian (PRC) | Cyrillic_General_100_ | New to SQL Server 2008 |
Nepali (Nepal) | Nepali_100_1 | New to SQL Server 2008 |
Norwegian (Bokmål, Norway) | Norwegian_100_ | New to SQL Server 2008 |
Norwegian (Nynorsk, Norway) | Norwegian_100_ | New to SQL Server 2008 |
Occitan (France) | French_100_ | New to SQL Server 2008 |
Oriya (India) | Indic_General_100_1 | New to SQL Server 2008 |
Pashto (Afghanistan) | Pashto_100_1 | New to SQL Server 2008 |
Persian (Iran) | Persian_100_ | New to SQL Server 2008 |
Polish (Poland) | Polish_100_ | Polish_ |
Portuguese (Brazil) | Latin1_General_100_ | Latin1_General_ |
Portuguese (Portugal) | Latin1_General_100_ | Latin1_General_ |
Punjabi (India) | Indic_General_100_1 | Indic_General_90_ |
Quechua (Bolivia) | Latin1_General_100_ | New to SQL Server 2008 |
Quechua (Ecuador) | Latin1_General_100_ | New to SQL Server 2008 |
Quechua (Peru) | Latin1_General_100_ | New to SQL Server 2008 |
Romanian (Romania) | Romanian_100_ | Romanian_ |
Romansh (Switzerland) | Romansh_100_ | New to SQL Server 2008 |
Russian (Russia) | Cyrillic_General_100_ | Cyrillic_General_ |
Sami (Inari, Finland) | Sami_Sweden_Finland_100_ | New to SQL Server 2008 |
Sami (Lule,Norway) | Sami_Norway_100_ | New to SQL Server 2008 |
Sami (Lule, Sweden) | Sami_Sweden_Finland_100_ | New to SQL Server 2008 |
Sami (Northern, Finland) | Sami_Sweden_Finland_100_ | New to SQL Server 2008 |
Sami (Northern,Norway) | Sami_Norway_100_ | New to SQL Server 2008 |
Sami (Northern, Sweden) | Sami_Sweden_Finland_100_ | New to SQL Server 2008 |
Sami (Skolt, Finland) | Sami_Sweden_Finland_100_ | New to SQL Server 2008 |
Sami (Southern, Norway) | Sami_Norway_100_ | New to SQL Server 2008 |
Sami (Southern, Sweden) | Sami_Sweden_Finland_100_ | New to SQL Server 2008 |
Sanskrit (India) | Indic_General_100_1 | Indic_General_90_ |
Serbian (Bosnia and Herzegovina, Cyrillic) | Serbian_Cyrillic_100_ | New to SQL Server 2008 |
Serbian (Bosnia and Herzegovina, Latin) | Serbian_Latin_100_ | New to SQL Server 2008 |
Serbian (Serbia, Cyrillic) | Serbian_Cyrillic_100_ | New to SQL Server 2008 |
Serbian (Serbia, Latin) | Serbian_Latin_100_ | New to SQL Server 2008 |
Sesotho sa Leboa/Northern Sotho (South Africa) | Latin1_General_100_ | New to SQL Server 2008 |
Setswana/Tswana (South Africa) | Latin1_General_100_ | New to SQL Server 2008 |
Sinhala (Sri Lanka) | Indic_General_100_1 | New to SQL Server 2008 |
Slovak (Slovakia) | Slovak_100_ | Slovak_ |
Slovenian (Slovenia) | Slovenian_100_ | Slovenian_ |
Spanish (Argentina) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Bolivia) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Chile) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Colombia) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Costa Rica) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Dominican Republic) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Ecuador) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (El Salvador) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Guatemala) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Honduras) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Mexico) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Nicaragua) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Panama) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Paraguay) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Peru) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Puerto Rico) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Spain) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Spain, Traditional Sort) | Traditional_Spanish_100_ | Traditional_Spanish_ |
Spanish (United States) | Latin1_General_100_ | New to SQL Server 2008 |
Spanish (Uruguay) | Modern_Spanish_100_ | Modern_Spanish_ |
Spanish (Venezuela) | Modern_Spanish_100_ | Modern_Spanish_ |
Swahili (Kenya) | Latin1_General_100_ | New to SQL Server 2008 |
Swedish (Finland) | Finnish_Swedish_100_ | Finnish_Swedish_ |
Swedish (Sweden) | Finnish_Swedish_100_ | Finnish_Swedish_ |
Syriac (Syria) | Syriac_100_1 | Syriac_90_ |
Tajik (Tajikistan) | Cyrillic_General_100_ | New to SQL Server 2008 |
Tamazight (Algeria, Latin) | Tamazight_100_ | New to SQL Server 2008 |
Tamil (India) | Indic_General_100_1 | Indic_General_90_ |
Tatar (Russia) | Tatar_100_ | Tatar_90_, Cyrillic_General_ |
Telugu (India) | Indic_General_100_1 | Indic_General_90_ |
Thai (Thailand) | Thai_100_ | Thai_ |
Tibetan (PRC) | Tibetan_100_1 | New to SQL Server 2008 |
Turkish (Turkey) | Turkish_100_ | Turkish_ |
Turkmen (Turkmenistan) | Turkmen_100_ | New to SQL Server 2008 |
Uighur (PRC) | Uighur_100_ | New to SQL Server 2008 |
Ukrainian (Ukraine) | Ukrainian_100_ | Ukrainian_ |
Upper Sorbian (Germany) | Upper_Sorbian_100_ | New to SQL Server 2008 |
Urdu (Pakistan) | Urdu_100_ | New to SQL Server 2008 |
Uzbek (Uzbekistan, Cyrillic) | Cyrillic_General_100_ | Cyrillic_General_ |
Uzbek (Uzbekistan, Latin) | Uzbek_Latin_100_ | Uzbek_Latin_90_ |
Vietnamese (Vietnam) | Vietnamese_100_ | Vietnamese_ |
Welsh (United Kingdom) | Welsh_100_ | New to SQL Server 2008 |
Wolof (Senegal) | French_100_ | New to SQL Server 2008 |
Xhosa/isiXhosa (South Africa) | Latin1_General_100_ | New to SQL Server 2008 |
Yakut (Russia) | Yakut_100_ | New to SQL Server 2008 |
Yi (PRC) | Latin1_General_100_ | New to SQL Server 2008 |
Yoruba (Nigeria) | Latin1_General_100_ | New to SQL Server 2008 |
Zulu/isiZulu (South Africa) | Latin1_General_100_ | New to SQL Server 2008 |
Deprecated, not available at server level in SQL Server 2008 | Hindi | Hindi |
Deprecated, not available at server level in SQL Server 2008 | Korean_Wansung_Unicode | Korean_Wansung_Unicode |
Deprecated, n ot available at server level in SQL Server 2008 | Lithuanian_Classic | Lithuanian_Classic |
Deprecated,Not available at server level in SQL Server 2008 | Macedonian | Macedonian |
1Unicode-only Windows collations can only be applied to column-level or expression-level data. They cannot be used as server or database collations.
