Collation order in SELECT statements
The SELECT statement performs a query and collation can affect the order of parts of the SELECT statement.
Collation order affects the following parts of the SELECT statement:
- The ORDER BY clause
- The relational, BETWEEN, and IN operators of the WHERE clause
- The MATCHES and LIKE conditions of the WHERE clause