Windows Collation Name (Transact-SQL)
Specifies the Windows collation name in the COLLATE clause. The Windows collation name is composed of the collation designator and the comparison styles.
.gif "Topic link icon")
Syntax
<Windows_collation_name> :: = CollationDesignator_<ComparisonStyle>
<ComparisonStyle> :: = { CaseSensitivity_AccentSensitivity [ _KanatypeSensitive ] [ _WidthSensitive ] }
| { _BIN | _BIN2 }
Arguments
CollationDesignator
Specifies the base collation rules used by the Windows collation. The base collation rules cover the following:The sorting rules that are applied when dictionary sorting is specified. Sorting rules are based on alphabet or language.
The code page used to store non-Unicode character data.
Some examples are:
Latin1_General or French: both use code page 1252.
Turkish: uses code page 1254.
CaseSensitivity
CI specifies case-insensitive, CS specifies case-sensitive.AccentSensitivity
AI specifies accent-insensitive, AS specifies accent-sensitive.KanatypeSensitive
Omitted specifies kanatype-insensitive, KS specifies kanatype-sensitive.WidthSensitivity
Omitted specifies width-insensitive, WS specifies width-sensitive.BIN
Specifies the backward-compatible binary sort order to be used.BIN2
Specifies the binary sort order that uses code-point comparison semantics introduced in SQL Server 2005.
Examples
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.
Remarks
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.
New Windows Collations in SQL Server 2008
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 20082 |
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, not 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.
2Like the Chinese (Taiwan) collation, Chinese (Macau) uses the rules of Simplified Chinese; unlike Chinese (Taiwan), it uses code page 950.