Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

sort_collation option [database]

Allows implicit use of the SORTKEY function on ORDER BY expressions.

Internal, collation_name, or collation_id

Internal

When the value of this option is Internal, the ORDER BY clause remains unchanged.

When the value of this option is set to a valid collation name or collation ID, any string expression in the ORDER BY clause is treated as if the SORTKEY function had been invoked.

• SORTKEY function [String]

Set the sort collation to binary:

SET TEMPORARY OPTION sort_collation='binary';

Having the sort collation set to binary transforms the following queries:

SELECT Name, ID
FROM Products
ORDER BY Name, ID;
SELECT name, ID
FROM Products
ORDER BY 1, 2;

The queries are transformed into:

SELECT Name, ID
FROM Products
ORDER BY SORTKEY(Name, 'binary'), ID;