Selecting a SQL Collation
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 | Swedish/Finnish (Standard) dictionary order, case-insensitive, uppercase preference, for use with 1252 character set. |
| 185 | Swedish/Finnish (Phone) dictionary order, case-insensitive, uppercase preference, for use with 1252 character set. |
| 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. |