Selecting a SQL Collation

Installing SQL Server (SQL Server 2000)

New Information - SQL Server 2000 SP3.

When selecting a SQL collation in the Collations Settings screen, use the following table to make the installation of Microsoft® SQL Server™ 2000 compatible with an installation of an earlier version of SQL Server.

Note Each SQL Collation name has an equivalent string in T-SQL code. For a list of sort order identifiers and the T-SQL version, see SQL Collation Name.

In the table, the left column lists the sort order ID of an instance of SQL Server 7.0 or SQL Server 6.5. The right column lists the SQL Server 2000 collation recommended for compatibility.

Sort order ID	SQL collation name
30	Binary order, for use with the 437 (U.S. English) character set.
31	Dictionary order, case-sensitive, for use with the 437 (U.S. English) character set.
32	Dictionary order, case-insensitive, for use with the 437 (U.S. English) character set.
33	Dictionary order, case-insensitive, uppercase preference, for use with the 437 (U.S. English) character set.
34	Dictionary order, case-insensitive, accent-insensitive, for use with the 437 (U.S. English) character set.
40	Binary order, for use with the 850 (Multilingual) character set.
41	Dictionary order, case-sensitive, for use with the 850 (Multilingual) character set.
42	Dictionary order, case-insensitive, for use with the 850 (Multilingual) character set.
43	Dictionary order, case-insensitive, uppercase preference, for use with the 850 (Multilingual) character set.
44	Dictionary order, case-insensitive, accent-insensitive, for use with the 850 (Multilingual) character set.
49	Strict compatibility with version 1.x case-insensitive databases, for use with the 850 (Multilingual) character set.
50	Binary order for use with 1252 character set.
51	Dictionary order, case-sensitive, for use with 1252 character set.
52	Dictionary order, case-insensitive, for use with 1252 character set.
53	Dictionary order, case-insensitive, uppercase preference, for use with 1252 character set.
54	Dictionary order, case-insensitive, accent-insensitive, for use with 1252 character set.
55	Alternate dictionary order, case-sensitive, for use with the 850 (Multilingual) character set.
56	Alternate dictionary order, case-insensitive, uppercase preference, for use with the 850 (Multilingual) character set.
57	Alternate dictionary order, case-insensitive, accent-insensitive, for use with the 850 (Multilingual) character set.
58	Scandinavian dictionary order, case-insensitive, uppercase preference, for use with the 850 (Multilingual) character set.
59	Scandinavian dictionary order, case-sensitive, for use with the 850 (Multilingual) character set.
60	Scandinavian dictionary order, case-insensitive, for use with the 850 (Multilingual) character set.
61	Alternate dictionary order, case-insensitive, for use with the 850 (Multilingual) character set.
71	Latin-1 case-sensitive, for use with 1252 character set.
72	Latin-1 case-insensitive, for use with 1252 character set.
73	Danish/Norwegian case-sensitive sort order for code page 1252.
74	Finnish/Swedish case-sensitive sort order for code page 1252.
75	Icelandic case-sensitive sort order for code page 1252.
80	Binary order, for use with the 1250 (Central European) character set.
81	Dictionary order, case-sensitive, for use with the 1250 (Central European) character set.
82	Dictionary order, case-insensitive, for use with the 1250 (Central European) character set.
83	Czech dictionary order, case-sensitive, for use with the 1250 (Central European) character set.
84	Czech dictionary order, case-insensitive, for use with the 1250 (Central European) character set.
85	Hungarian dictionary order, case-sensitive, for use with the 1250 (Central European) character set.
86	Hungarian dictionary order, case-insensitive, for use with the 1250 (Central European) character set.
87	Polish dictionary order, case-sensitive, for use with the 1250 (Central European) character set.
88	Polish dictionary order, case-insensitive, for use with the 1250 (Central European) character set.
89	Romanian dictionary order, case-sensitive, for use with the 1250 (Central European) character set.
90	Romanian dictionary order, case-insensitive, for use with the 1250 (Central European) character set.
91	Croatian dictionary order, case-sensitive, for use with the 1250 (Central European) character set.
92	Croatian dictionary order, case-insensitive, for use with the 1250 (Central European) character set.
93	Slovak dictionary order, case-sensitive, for use with the 1250 (Central European) character set.
94	Slovak dictionary order, case-insensitive, for use with the 1250 (Central European) character set.
95	Slovenian dictionary order, case-sensitive, for use with the 1250 (Central European) character set.
96	Slovenian dictionary order, case-insensitive, for use with the 1250 (Central European) character set.
97	Windows Polish case-sensitive sort order for code page 1250.
98	Windows Polish case-insensitive sort order for code page 1250.
104	Binary order, for use with the 1251 (Cyrillic) character set.
105	Dictionary order, case-sensitive, for use with the 1251 (Cyrillic) character set.
106	Dictionary order, case-insensitive, for use with the 1251 (Cyrillic) character set.
107	Ukrainian dictionary order, case-sensitive, for use with the 1251 (Cyrillic) character set.
108	Ukrainian dictionary order, case-insensitive, for use with the 1251 (Cyrillic) character set.
112	Binary order, for use with the 1253 (Greek) character set.
113	Dictionary order, case-sensitive, for use with the 1253 (Greek) character set.
114	Dictionary order, case-insensitive, for use with the 1253 (Greek) character set.
120	Mixed dictionary order, for use with the 1253 (Greek) character set.
121	Dictionary order, case-sensitive, accent-sensitive, for use with the 1253 (Greek) character set.
124	Dictionary order, case-insensitive, accent-insensitive, for use with the 1253 (Greek) character set.
128	Binary order, for use with the 1254 (Turkish) character set.
129	Dictionary order, case-sensitive, for use with the 1254 (Turkish) character set.
130	Dictionary order, case-insensitive, for use with the 1254 (Turkish) character set.
136	Binary order, for use with the 1255 (Hebrew) character set.
137	Dictionary order, case-sensitive, for use with the 1255 (Hebrew) character set.
138	Dictionary order, case-insensitive, for use with the 1255 (Hebrew) character set.
144	Binary order, for use with the 1256 (Arabic) character set.
145	Dictionary order, case-sensitive, for use with the 1256 (Arabic) character set.
146	Dictionary order, case-insensitive, for use with the 1256 (Arabic) character set.
152	Binary order, for use with the 1257 (Baltic) character set.
153	Dictionary order, case-sensitive, for use with the 1257 (Baltic) character set.
154	Dictionary order, case-insensitive, for use with the 1257 (Baltic) character set.
155	Estonian dictionary order, case-sensitive, for use with the 1257 (Baltic) character set.
156	Estonian dictionary order, case-insensitive, for use with the 1257 (Baltic) character set.
157	Latvian dictionary order, case-sensitive, for use with the 1257 (Baltic) character set.
158	Latvian dictionary order, case-insensitive, for use with the 1257 (Baltic) character set.
159	Lithuanian dictionary order, case-sensitive, for use with the 1257 (Baltic) character set.
160	Lithuanian dictionary order, case-insensitive, for use with the 1257 (Baltic) character set.
183	Danish/Norwegian dictionary order, case-insensitive, uppercase preference, for use with 1252 character set.
184	Finnish-Swedish (Phone), case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 184 on Code Page 1252 for non-Unicode Data.
185	Finnish-Swedish (Standard), case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 185 on Code Page 1252 for non-Unicode Data.
186	Icelandic dictionary order, case-insensitive, uppercase preference, for use with 1252 character set.
192	Binary order, for use with the 932 (Japanese) character set.
193	Dictionary order, case-insensitive, for use with the 932 (Japanese) character set
194	Binary order, for use with the 949 (Korean) character set.
195	Dictionary order, case-insensitive, for use with the 949 (Korean) character set.
196	Binary order, for use with the 950 (Traditional Chinese) character set.
197	Dictionary order, case-insensitive, for use with the 950 (Traditional Chinese) character set.
198	Binary order, for use with the 936 (Simplified Chinese) character set.
199	Dictionary order, case-insensitive, for use with the 936 (Simplified Chinese) character set.
200	Dictionary order, case-sensitive, for use with the 932 (Japanese) character set.
201	Dictionary order, case-sensitive, for use with the 949 (Korean) character set.
202	Dictionary order, case-sensitive, for use with the 950 (Traditional Chinese) character set.
203	Dictionary order, case-sensitive, for use with the 936 (Simplified Chinese) character set.
204	Binary order, for use with the 874 (Thai) character set.
205	Dictionary order, case-insensitive, for use with the 874 (Thai) character set.
206	Dictionary order, case-sensitive, for use with the 874 (Thai) character set.

See Also