Sort Orders

The sort order chosen for a server determines the order in which SQL Server sorts data in response to queries, as well as the results that SQL Server returns for queries that involve character comparisons.

For information, choose one of these topics:

About Sort Orders

Dictionary Order, Case-insensitive

Binary Order

Dictionary Order, Case-sensitive

Dictionary Order, Case-insensitive, Uppercase Preference

Dictionary Order, Case-insensitive, Accent-insensitive

Additional Sort Orders for Code Page 850

Sort Order IDs

Performance Comparisons