Collation Tables

There are two types of collation tables you can use to perform multilingual sorting.

The two ways to use sortkey are:

You can view a list of available collation rules. Print the list by executing either sp_helpsort, or by querying and selecting the name, id, and description from syscharsets (type is between 2003 and 2999).