SQL Collation Name (Transact-SQL)
Is a single string that specifies the collation name for a SQL collation.
Transact-SQL Syntax Conventions
- SortRules
-
A string identifying the alphabet or language whose sorting rules are applied when dictionary sorting is specified. Examples are Latin1_General or Polish.
- Pref
-
Specifies uppercase preference.
- Codepage
-
Specifies a one- to four-digit number that identifies the code page used by the collation. CP1 specifies code page 1252, for all other code pages the complete code page number is specified. For example, CP1251 specifies code page 1251 and CP850 specifies code page 850.
- CaseSensitivity
-
CI specifies case-insensitive, CS specifies case-sensitive.
- AccentSensitivity
-
AI specifies accent-insensitive, AS specifies accent-sensitive.
- BIN
-
Specifies the binary sort order is to be used.
The following table lists the SQL collation names.
| Sort order ID | SQL collation name |
|---|---|
|
30 |
SQL_Latin1_General_Cp437_BIN |
|
31 |
SQL_Latin1_General_Cp437_CS_AS |
|
32 |
SQL_Latin1_General_Cp437_CI_AS |
|
33 |
SQL_Latin1_General_Pref_CP437_CI_AS |
|
34 |
SQL_Latin1_General_Cp437_CI_AI |
|
40 |
SQL_Latin1_General_Cp850_BIN |
|
41 |
SQL_Latin1_General_Cp850_CS_AS |
|
42 |
SQL_Latin1_General_Cp850_CI_AS |
|
43 |
SQL_Latin1_General_Pref_CP850_CI_AS |
|
44 |
SQL_Latin1_General_Cp850_CI_AI |
|
49 |
SQL_1Xcompat_CP850_CI_AS |
|
50 |
Latin1_General_BIN |
|
51 |
SQL_Latin1_General_Cp1_CS_AS |
|
52 |
SQL_Latin1_General_Cp1_CI_AS |
|
53 |
SQL_Latin1_General_Pref_CP1_CI_AS |
|
54 |
SQL_Latin1_General_Cp1_CI_AI |
|
55 |
SQL_AltDiction_Cp850_CS_AS |
|
56 |
SQL_AltDiction_Pref_CP850_CI_AS |
|
57 |
SQL_AltDiction_Cp850_CI_AI |
|
58 |
SQL_Scandinavian_Pref_Cp850_CI_AS |
|
59 |
SQL_Scandinavian_Cp850_CS_AS |
|
60 |
SQL_Scandinavian_Cp850_CI_AS |
|
61 |
SQL_AltDiction_Cp850_CI_AS |
|
71 |
Latin1_General_CS_AS |
|
72 |
Latin1_General_CI_AS |
|
73 |
Danish_Norwegian_CS_AS |
|
74 |
Finnish_Swedish_CS_AS |
|
75 |
Icelandic_CS_AS |
|
80 |
Hungarian_BIN (or Albanian_BIN, Czech_BIN, and so on1) |
|
81 |
SQL_Latin1_General_Cp1250_CS_AS |
|
82 |
SQL_Latin1_General_Cp1250_CI_AS |
|
83 |
SQL_Czech_Cp1250_CS_AS |
|
84 |
SQL_Czech_Cp1250_CI_AS |
|
85 |
SQL_Hungarian_Cp1250_CS_AS |
|
86 |
SQL_Hungarian_Cp1250_CI_AS |
|
87 |
SQL_Polish_Cp1250_CS_AS |
|
88 |
SQL_Polish_Cp1250_CI_AS |
|
89 |
SQL_Romanian_Cp1250_CS_AS |
|
90 |
SQL_Romanian_Cp1250_CI_AS |
|
91 |
SQL_Croatian_Cp1250_CS_AS |
|
92 |
SQL_Croatian_Cp1250_CI_AS |
|
93 |
SQL_Slovak_Cp1250_CS_AS |
|
94 |
SQL_Slovak_Cp1250_CI_AS |
|
95 |
SQL_Slovenian_Cp1250_CS_AS |
|
96 |
SQL_Slovenian_Cp1250_CI_AS |
|
104 |
Cyrillic_General_BIN (or Ukrainian_BIN, Macedonian_FYROM_90_BIN) |
|
105 |
SQL_Latin1_General_Cp1251_CS_AS |
|
106 |
SQL_Latin1_General_Cp1251_CI_AS |
|
107 |
SQL_Ukrainian_Cp1251_CS_AS |
|
108 |
SQL_Ukrainian_Cp1251_CI_AS |
|
112 |
Greek_BIN |
|
113 |
SQL_Latin1_General_Cp1253_CS_AS |
|
114 |
SQL_Latin1_General_Cp1253_CI_AS |
|
120 |
SQL_MixDiction_Cp1253_CS_AS |
|
121 |
SQL_AltDiction_Cp1253_CS_AS |
|
124 |
SQL_Latin1_General_Cp1253_CI_AI |
|
128 |
Turkish_BIN |
|
129 |
SQL_Latin1_General_Cp1254_CS_AS |
|
130 |
SQL_Latin1_General_Cp1254_CI_AS |
|
136 |
Hebrew_BIN |
|
137 |
SQL_Latin1_General_Cp1255_CS_AS |
|
138 |
SQL_Latin1_General_Cp1255_CI_AS |
|
144 |
Arabic_BIN |
|
145 |
SQL_Latin1_General_Cp1256_CS_AS |
|
146 |
SQL_Latin1_General_Cp1256_CI_AS |
|
153 |
SQL_Latin1_General_Cp1257_CS_AS |
|
154 |
SQL_Latin1_General_Cp1257_CI_AS |
|
155 |
SQL_Estonian_Cp1257_CS_AS |
|
156 |
SQL_Estonian_Cp1257_CI_AS |
|
157 |
SQL_Latvian_Cp1257_CS_AS |
|
158 |
SQL_Latvian_Cp1257_CI_AS |
|
159 |
SQL_Lithuanian_Cp1257_CS_AS |
|
160 |
SQL_Lithuanian_Cp1257_CI_AS |
|
183 |
SQL_Danish_Pref_Cp1_CI_AS |
|
184 |
SQL_SwedishPhone_Pref_Cp1_CI_AS |
|
185 |
SQL_SwedishStd_Pref_Cp1_CI_AS |
|
186 |
SQL_Icelandic_Pref_Cp1_CI_AS |
|
192 |
Japanese_BIN |
|
193 |
Japanese_CI_AS |
|
194 |
Korean_Wansung_BIN |
|
195 |
Korean_Wansung_CI_AS |
|
196 |
Chinese_Taiwan_Stroke_BIN |
|
197 |
Chinese_Taiwan_Stroke_CI_AS |
|
198 |
Chinese_PRC_BIN |
|
199 |
Chinese_PRC_CI_AS |
|
200 |
Japanese_CS_AS |
|
201 |
Korean_Wansung_CS_AS |
|
202 |
Chinese_Taiwan_Stroke_CS_AS |
|
203 |
Chinese_PRC_CS_AS |
|
204 |
Thai_BIN |
|
205 |
Thai_CI_AS |
|
206 |
Thai_CS_AS |
|
210 |
SQL_EBCDIC037_CP1_CS_AS |
|
211 |
SQL_EBCDIC273_CP1_CS_AS |
|
212 |
SQL_EBCDIC277_CP1_CS_AS |
|
213 |
SQL_EBCDIC278_CP1_CS_AS |
|
214 |
SQL_EBCDIC280_CP1_CS_AS |
|
215 |
SQL_EBCDIC284_CP1_CS_AS |
|
216 |
SQL_EBCDIC285_CP1_CS_AS |
|
217 |
SQL_EBCDIC297_CP1_CS_AS |
1For Sort Order ID 80, use any of the Window collations with the code page of 1250, and binary order. For example: Albanian_BIN, Croatian_BIN, Czech_BIN, Romanian_BIN, Slovak_BIN, Slovenian_BIN.
