(mysql.info.gz) Charset-binary-op

Info Catalog

(mysql.info.gz) Charset-collate-precedence

(mysql.info.gz) Charset-defaults

(mysql.info.gz) Charset-collate-tricky

 
 10.3.10 `BINARY' Operator
 -------------------------
 
 The `BINARY' operator is a shorthand for a `COLLATE' clause.  `BINARY
 'x'' is equivalent to `'x' COLLATE y', where `y' is the name of the
 binary collation for the character set of `'x''.  Every character set
 has a binary collation.  For example, the binary collation for the
 `latin1' character set is `latin1_bin', so if the column `a' is of
 character set `latin1', the following two statements have the same
 effect:
 
      SELECT * FROM t1 ORDER BY BINARY a;
      SELECT * FROM t1 ORDER BY a COLLATE latin1_bin;
 

Info Catalog

(mysql.info.gz) Charset-collate-precedence

(mysql.info.gz) Charset-defaults

(mysql.info.gz) Charset-collate-tricky