Windows Collation Name
Specifies the Windows collation name in the COLLATE clause. The Windows collations name is composed of the collation designator and the comparison styles.
Syntax
< Windows_collation_name > :: =
CollationDesignator_<ComparisonStyle>
< ComparisonStyle > :: =
CaseSensitivity_AccentSensitivity
[_KanatypeSensitive [_WidthSensitive ] ]
| _BIN
Arguments
CollationDesignator
Specifies the base collation rules used by the Windows collation. The base collation rules cover:
- The alphabet or language whose sorting rules are applied when dictionary sorting is specified
- The code page used to store non-Unicode character data.
Examples are Latin1_General or French, both of which use code page 1252, or Turkish, which 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 case-insensitive, KS specifies kanatype-sensitive.
WidthSensitivity
Omitted specifies case-insensitive, WS specifies case-sensitive.
BIN
Specifies the binary sort order is to be used.
Remarks
The collation designators for Microsoft® SQL Server™ 2000 Windows collations are:
| SQL Server 2000 Collation Designator | Code Page for non-Unicode data | Supported Windows Locales |
|---|---|---|
| Albanian | 1250 | Albanian |
| Arabic | 1256 | Arabic (Algeria), Arabic (Bahrain), Arabic (Egypt), Arabic (Iraq), Arabic (Jordan), Arabic (Kuwait), Arabic (Lebanon), Arabic (Libya), Arabic (Morocco), Arabic (Oman), Arabic (Qatar), Arabic (Saudi Arabia), Arabic (Syria), Arabic (Tunisia), Arabic (United Arab Emirates), Arabic (Yemen), Farsi, Urdu |
| Chinese_PRC | 936 | Chinese (Hong Kong S.A.R.), Chinese (People's Republic of China), Chinese (Singapore) |
| Chinese_PRC_Stroke | 936 | Stroke sort with Chinese (PRC) |
| Chinese_Taiwan_Bopomofo | 950 | Bopomofo with Chinese (Taiwan) |
| Chinese_Taiwan_Stroke | 950 | Chinese (Taiwan) |
| Croatian | 1250 | Croatian |
| Cyrillic_General | 1251 | Bulgarian, Byelorussian, Russian, Serbian |
| Czech | 1250 | Czech |
| Danish_Norwegian | 1252 | Danish, Norwegian (Bokmål), Norwegian (Nyorsk) |
| Estonian | 1257 | Estonian |
| Finnish_Swedish | 1252 | Finnish, Swedish |
| French | 1252 | French (Belgium), French (Canada), French (Luxemburg), French (Standard), French (Switzerland) |
| Georgian_Modern_Sort | 1252 | Modern Sort with Georgian |
| German_PhoneBook | 1252 | PhoneBook sort with German |
| Greek | 1253 | Greek |
| Hebrew | 1255 | Hebrew |
| Hindi | For Unicode data types only | Hindi |
| Hungarian | 1250 | Hungarian |
| Hungarian_Technical | 1250 | |
| Icelandic | 1252 | Icelandic |
| Japanese | 932 | Japanese |
| Japanese_Unicode | 932 | |
| Korean_Wansung | 949 | Korean |
| Korean_Wansung_Unicode | 949 | |
| Latin1_General | 1252 | Afrikaans, Basque, Catalan, Dutch (Belgium), Dutch (Standard), English (Australia), English (Britain), English (Canada), English (Carribbean) English (Ireland), English (Jamaican), English (New Zealand), English (South Africa), English (United States), Faeroese, German (Austria), German (Liechtenstein), German (Luxembourg), German (Standard), German (Switzerland), Indonesian, Italian, Italian (Switzerland), Portuguese (Brazil), Portuguese (Standard) |
| Latvian | 1257 | Latvian |
| Lithuanian | 1257 | Lithuanian |
| Lithuanian_Classic | 1257 | |
| Macedonian | 1251 | Macedonian |
| Mexican_Trad_Spanish | 1252 | Spanish (Mexican), Spanish (Traditional Sort) |
| Modern_Spanish | 1252 | Spanish (Argentina), Spanish (Bolivia), Spanish (Chile), Spanish (Colombia), Spanish (Costa Rica), Spanish (Dominican Republic), Spanish (Ecuador), Spanish (Guatemala), Spanish (Modern Sort), Spanish (Panama), Spanish (Paraguay), Spanish (Peru), Spanish (Uruguay), Spanish (Venezuela) |
| Polish | 1250 | Polish |
| Romanian | 1250 | Romanian |
| Slovak | 1250 | Slovak |
| Slovenian | 1250 | Slovenian |
| Thai | 874 | Thai |
| Turkish | 1254 | Turkish |
| Ukrainian | 1251 | Ukrainian |
| Vietnamese | 1258 | Vietnamese |
Examples
These are some examples of Windows collation names:
- Latin1_General_CI_AS
Collation uses the Latin1 General dictionary sorting rules, code page 1252. Is case-insensitive and accent-sensitive.
- 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.