Export (0) Print
Expand All

Windows Collation Name

SQL Server 2000

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 kanatype-insensitive, KS specifies kanatype-sensitive.

WidthSensitivity

Omitted specifies width-insensitive, WS specifies width-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 (Great Britain), English (Canada), English (Caribbean) 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 (Portugal)
Latvian 1257 Latvian
Lithuanian 1257 Lithuanian
Lithuanian_Classic 1257
FYRO Macedonian 1251 Macedonian (FYROM)
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.

See Also

ALTER TABLE

Collation Settings in Setup

Constants

CREATE DATABASE

CREATE TABLE

DECLARE @local_variable

table

Windows Collation Names Table

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft