Selecting a SQL Collation

Article
12/03/2008

This topic presents SQL Server collation options for Microsoft SQL Server instances that require compatibility with earlier versions of SQL Server that do not use collations.

The following SQL Server 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 Server collation name has an equivalent string in Transact-SQL code. For a list of sort order identifiers and their Transact-SQL equivalents, see SQL Collation Name (Transact-SQL).

Share via

Selecting a SQL Collation

See Also

Reference

Concepts

Help and Information

Additional resources