The following table lists the SQL Server collation names.
|
Sort order ID
|
SQL Server 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
|