Selecting a SQL Server Collation
This topic describes SQL Server 2008 collation options for instances of SQL Server that require compatibility with versions of SQL Server that do not use collations.
The following SQL collations are listed on the Collation Settings page of the SQL Server Installation Wizard.
SQL sort order ID |
Sort order name |
Description |
SQL collation |
|---|---|---|---|
31 |
diction.437 |
Dictionary order, case-sensitive |
SQL_Latin1_General_Cp437_CS_AS_KI_WI |
32 |
nocase.437 |
Dictionary order, case-insensitive |
SQL_Latin1_General_Cp437_CI_AS_KI_WI |
33 |
nocasepr.437 |
Dictionary order, case-insensitive, uppercase preference |
SQL_Latin1_General_Pref_Cp437_CI_AS_KI_WI |
34 |
noaccent.437 |
Dictionary order, case-insensitive, accent-insensitive |
SQL_Latin1_General_Cp437_CI_AI_KI_WI |
40 |
cp437bin.437 |
Binary |
SQL_Latin1_General_Cp437_BIN |
40 |
cp850bin.850 |
Binary |
SQL_Latin1_General_Cp850_BIN |
41 |
diction.850 |
Dictionary order, case-sensitive |
SQL_Latin1_General_Cp850_CS_AS_KI_WI |
42 |
nocase.850 |
Dictionary order, case-insensitive |
SQL_Latin1_General_Cp850_CI_AS_KI_WI |
44 |
noaccent.850 |
Dictionary order, case-insensitive, accent-insensitive |
SQL_Latin1_General_Cp850_CI_AI_KI_WI |
44 |
nocase34.850 |
Dictionary order, case-insensitive, uppercase preference |
SQL_Latin1_General_Pref_Cp850_CI_AS_KI_WI |
49 |
nocase34.850 |
Strict compatibility with Version 1.x case-insensitive databases |
SQL_1xCompat_Cp850_CI_AS_KI_WI |
51 |
diction.iso |
Dictionary order, case-sensitive |
SQL_Latin1_General_Cp1_CS_AS_KI_WI |
52 |
nocase.iso |
Dictionary order, case-insensitive |
SQL_Latin1_General_Cp1_CI_AS_KI_WI |
53 |
nocasepr.iso |
Dictionary order, case-insensitive, uppercase preference |
SQL_Latin1_General_Pref_Cp1_CI_AS_KI_WI |
54 |
noaccent.iso |
Dictionary order, case-insensitive, accent-insensitive |
SQL_Latin1_General_Cp1_CI_AI_KI_WI |
55 |
altdict.850 |
Alternate dictionary order, case-sensitive |
SQL_AltDiction_Cp850_CS_AS_KI_WI |
56 |
altnocsp.850 |
Alternate dictionary order, case-insensitive, uppercase preference |
SQL_AltDiction_Pref_Cp850_CI_AS_KI_WI |
57 |
altnoacc.850 |
Alternate dictionary order, case-insensitive, accent-insensitive |
SQL_AltDiction_Cp850_CI_AI_KI_WI |
58 |
scan.850 |
Scandinavian dictionary sort order, case-insensitive, uppercase preference |
SQL_Scandainavian_Pref_Cp850_CI_AS_KI_WI |
59 |
scandict.850 |
Scandinavian dictionary sort order, case-sensitive |
SQL_Scandainavian_Cp850_CS_AS_KI_WI |
60 |
scannocase.850 |
Case-insensitive Scandinavian dictionary sort order, without case preference |
SQL_Scandainavian_Cp850_CI_AS_KI_WI |
61 |
altnocs.850 |
Alternate dictionary order, case-insensitive |
SQL_AltDiction_Cp850_CI_AS_KI_WI |
80 |
binary.250 |
Binary |
SQL_Latin1_General_1250_BIN |
81 |
diction.250 |
Dictionary order, case-sensitive |
SQL_Latin1_General_Cp1250_CS_AS_KI_WI |
82 |
nocase.250 |
Dictionary order, case-insensitive |
SQL_Latin1_General_Cp1250_CI_AS_KI_WI |
83 |
csydic.250 |
Czech dictionary order, case-sensitive |
SQL_Czech_Cp1250_CS_AS_KI_WI |
84 |
csync.250 |
Czech dictionary order, case-insensitive |
SQL_Czech_Cp1250_CI_AS_KI_WI |
85 |
hundic.250 |
Hungarian dictionary order, case-sensitive |
SQL_Hungarian_Cp1250_CS_AS_KI_WI |
86 |
hunnc.250 |
Hungarian dictionary order, case-insensitive |
SQL_Hungarian_Cp1250_CI_AS_KI_WI |
87 |
plkdic.250 |
Polish dictionary order, case-sensitive |
SQL_Polish_Cp1250_CS_AS_KI_WI |
88 |
plknc.250 |
Polish dictionary order, case-insensitive |
SQL_Polish_Cp1250_CI_AS_KI_WI |
89 |
romdic.250 |
Romanian dictionary order, case-sensitive |
SQL_Romanian_Cp1250_CS_AS_KI_WI |
90 |
romnc.250 |
Romanian dictionary order, case-insensitive |
SQL_Romanian_Cp1250_CI_AS_KI_WI |
91 |
shldic.250 |
Croatian dictionary order, case-sensitive |
SQL_Croatian_Cp1250_CS_AS_KI_WI |
92 |
shlnc.250 |
Croatian dictionary order, case-insensitive |
SQL_Croatian_Cp1250_CI_AS_KI_WI |
93 |
skydic.250 |
Slovak dictionary order, case-sensitive |
SQL_Slovak_Cp1250_CS_AS_KI_WI |
94 |
skync.250 |
Slovak dictionary order, case-insensitive |
SQL_Slovak_Cp1250_CI_AS_KI_WI |
95 |
slvdic.250 |
Slovenian dictionary order, case-sensitive |
SQL_Slovenian_Cp1250_CS_AS_KI_WI |
96 |
slvnc.250 |
Slovenian dictionary order, case-insensitive |
SQL_Slovenian_Cp1250_CI_AS_KI_WI |
104 |
binary.250 |
Binary |
SQL_Latin1_General_1251_BIN |
105 |
diction.251 |
Dictionary order, case-sensitive |
SQL_Latin1_General_Cp1251_CS_AS_KI_WI |
106 |
nocase.251 |
Dictionary order, case-insensitive |
SQL_Latin1_General_Cp1251_CI_AS_KI_WI |
107 |
ukrdic.251 |
Ukrainian dictionary order, case-sensitive |
SQL_Ukrainian_Cp1251_CS_AS_KI_WI |
108 |
ukrnc.251 |
Ukrainian dictionary order, case-insensitive |
SQL_Ukrainian_Cp1251_CI_AS_KI_WI |
112 |
binary.253 |
Binary |
SQL_Latin1_General_1253_BIN |
113 |
diction.253 |
Dictionary order, case-sensitive |
SQL_Latin1_General_Cp1253_CS_AS_KI_WI |
114 |
nocase.253 |
Dictionary order, case-insensitive |
SQL_Latin1_General_Cp1253_CI_AS_KI_WI |
121 |
graltdct.253 |
Dictionary order, case-sensitive, accent-sensitive |
SQL_Latin1_General_Cp1253_CI_AS_KI_WI |
124 |
grnoacce.253 |
Dictionary order, case-insensitive, accent-insensitive |
SQL_Latin1_General_Cp1253_CI_AI_KI_WI |
128 |
binary.254 |
Binary |
SQL_Latin1_General_1254_BIN |
129 |
diction.254 |
Dictionary order, case-sensitive |
SQL_Latin1_General_Cp1254_CS_AS_KI_WI |
130 |
nocase.254 |
Dictionary order, case-insensitive |
SQL_Latin1_General_Cp1254_CI_AS_KI_WI |
136 |
binary.255 |
Binary |
SQL_Latin1_General_1255_BIN |
137 |
diction.255 |
Dictionary order, case-sensitive |
SQL_Latin1_General_Cp1255_CS_AS_KI_WI |
138 |
nocase.255 |
Dictionary order, case-insensitive |
SQL_Latin1_General_Cp1255_CI_AS_KI_WI |
144 |
binary.256 |
Binary |
SQL_Latin1_General_1256_BIN |
145 |
diction.256 |
Dictionary order, case-sensitive |
SQL_Latin1_General_Cp1256_CS_AS_KI_WI |
146 |
nocase.256 |
Dictionary order, case-insensitive |
SQL_Latin1_General_Cp1256_CI_AS_KI_WI |
152 |
binary.257 |
Binary |
SQL_Latin1_General_1257_BIN |
153 |
diction.257 |
Dictionary order, case-sensitive |
SQL_Latin1_General_Cp1257_CS_AS_KI_WI |
154 |
nocase.257 |
Dictionary order, case-insensitive |
SQL_Latin1_General_Cp1257_CI_AS_KI_WI |
155 |
etidic.257 |
Estonian dictionary order, case-sensitive |
SQL_Estonian_Cp1257_CS_AS_KI_WI |
156 |
etinc.257 |
Estonian dictionary order, case-insensitive |
SQL_Estonian_Cp1257_CI_AS_KI_WI |
157 |
lvidic.257 |
Latvian dictionary order, case-sensitive |
SQL_Latvian_Cp1257_CS_AS_KI_WI |
158 |
lvinc.257 |
Latvian dictionary order, case-insensitive |
SQL_Latvian_Cp1257_CI_AS_KI_WI |
159 |
lthdic.257 |
Lithuanian dictionary order, case-sensitive |
SQL_Lithuanian_Cp1257_CS_AS_KI_WI |
160 |
lthnc.257 |
Lithuanian dictionary order, case-insensitive |
SQL_Lithuanian_Cp1257_CI_AS_KI_WI |
183 |
danonocp.iso |
Danish/Norwegian dictionary order, case-insensitive, uppercase preference |
SQL_Danish_Pref_Cp1_CI_AS_KI_WI |
184 |
islanocp.iso |
Swedish/Finnish[Phone] dictionary order, case-insensitive, uppercase preference |
SQL_SwedishPhone_Pref_Cp1_CI_AS_KI_WI |
185 |
svf2nocp.iso.iso |
Swedish/Finnish[Std] dictionary order, case-insensitive, uppercase preference |
SQL_SwedishStd_Pref_Cp1_CI_AS_KI_WI |
186 |
islanocp.iso |
Icelandic dictionary order, case-insensitive, uppercase preference |
SQL_Icelandic_Pref_Cp1_CI_AS_KI_WI |
Note
Each SQL collation name has an equivalent string in Transact-SQL code. For more information, see SQL Server Collation Name (Transact-SQL).