Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Selecting a SQL Collation

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

Examples of SQL Collations

Collation Settings in Setup

Specifying Collations

SQL Collations

Show:
© 2015 Microsoft