Windows Collation Name (Transact-SQL)

Windows Collation Name (Transact-SQ...

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Language Filter

Other versions are also available for the following:

SQL Server 2005

SQL Server 2008 Books Online (June 2009)

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.

Topic link icon Transact-SQL Syntax Conventions

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.

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 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.

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.

New Windows Collations

All Windows Collations

Reference

Other Resources

Help and Information