DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) Charset-collate

Info Catalog (mysql.info.gz) Charset-literal (mysql.info.gz) Charset-defaults (mysql.info.gz) Charset-collate-precedence
 
 10.3.8 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;
 
    * With `HAVING':
 
           SELECT k
           FROM t1
           GROUP BY k
           HAVING k = _latin1 'Mu"ller' COLLATE latin1_german2_ci;
 
 
Info Catalog (mysql.info.gz) Charset-literal (mysql.info.gz) Charset-defaults (mysql.info.gz) Charset-collate-precedence
automatically generated byinfo2html