Comparisons with MATCHES and LIKE conditions

Collation rules also affect the WHERE clause when the expressions in the condition are column expressions with character data types and the search condition is either the MATCHES or LIKE condition.