(mysql.info) charset-collate

(mysql.info) charset-collate-precedence

 
 10.5.1 Using `COLLATE' in SQL Statements
 ----------------------------------------
 
 With the `COLLATE' clause, you can override whatever the default
 collation is for a comparison.  `COLLATE' may be used in various parts
 of SQL statements. Here are some examples:
 
    * With `ORDER BY':
 
           SELECT k
           FROM t1
           ORDER BY k COLLATE latin1_german2_ci;
 
    * With `AS':
 
           SELECT k COLLATE latin1_german2_ci AS k1
           FROM t1
           ORDER BY k1;
 
    * With `GROUP BY':
 
           SELECT k
           FROM t1
           GROUP BY k COLLATE latin1_german2_ci;
 
    * With aggregate functions:
 
           SELECT MAX(k COLLATE latin1_german2_ci)
           FROM t1;
 
    * With `DISTINCT':
 
           SELECT DISTINCT k COLLATE latin1_german2_ci
           FROM t1;
 
    * With `WHERE':
 
                SELECT *
                FROM t1
                WHERE _latin1 'Mu"ller' COLLATE latin1_german2_ci = k;
 
                SELECT *
                FROM t1
                WHERE k LIKE _latin1 'Mu"ller' COLLATE latin1_german2_ci;
 
    * With `HAVING':
 
           SELECT k
           FROM t1
           GROUP BY k
           HAVING k = _latin1 'Mu"ller' COLLATE latin1_german2_ci;

Info Catalog

(mysql.info) charset-collations

(mysql.info) charset-collate-precedence

automatically generated byinfo2html