The following table shows the sort order ID for each SQL Server sort order. The filename is the name of the corresponding sort order file installed in one of three character set directories under \SQL60\CHARSETS, and the filename extension indicates the corresponding character set.
| ID | Name | Filename |
|---|---|---|
| 30 | Binary order | CP437BIN.437 |
| 31 | Dictionary order, case-sensitive | DICTION.437 |
| 32 | Dictionary order, case-insensitive | NOCASE.437 |
| 33 | Dictionary order, case-insensitive, uppercase preference | NOCASEPR.437 |
| 34 | Dictionary order, case-insensitive, accent-insensitive | NOACCENT.437 |
| 40 | Binary order | CP850BIN.850 |
| 41 | Dictionary order, case-sensitive | DICTION.859 |
| 42 | Dictionary order, case-insensitive | NOCASE.850 |
| 43 | Dictionary order, case-insensitive, uppercase preference | NOCASEPR.850 |
| 44 | Dictionary order, case-insensitive, accent-insensitive | NOACCENT.850 |
| 49 | Strict compatibility with Version 1.x case-insensitive databases | NOCASE34.850 |
| 50 | Binary order | ISO_1BIN.ISO |
| 51 | Dictionary order, case-sensitive | DICTION.ISO |
| 52 | Dictionary order, case-insensitive | NOCASE.ISO |
| 53 | Dictionary order, case-insensitive, uppercase preference | NOCASEPR.ISO |
| 54 | Dictionary order, case-insensitive, accent-insensitive | NOACCENT.ISO |
| 55 | Alternate dictionary order, case-sensitive | ALTDICT.850 |
| 56 | Alternate dictionary order, case-insensitive, uppercase preference | ALTNOCSP.850 |
| 57 | Alternate dictionary order, case-insensitive, accent-insensitive | ALTNOACC.850 |
| 58 | Scandinavian dictionary order, case-insensitive, uppercase preference | SCANNOCP.850 |
| 59 | Scandinavian dictionary order, case-sensitive | SCANDICT.850 |
| 61 | Alternate dictionary order, case-insensitive | ALTNOCS.850 |
Note Additional character sets and sort orders are being developed for international users and may be included in those listed by the setup program.