(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