(mysql.info) charset-collation-charset

Info Catalog

(mysql.info) charset-collate-tricky

(mysql.info) charset-collations

(mysql.info) charset-collation-effect

 
 10.5.5 Collations Must Be for the Right Character Set
 -----------------------------------------------------
 
 Cach character set has one or more collations, but each collation is
 associated with one and only one character set.  Therefore, the
 following statement causes an error message because the `latin2_bin'
 collation is not legal with the `latin1' character set:
 
      mysql> SELECT _latin1 'x' COLLATE latin2_bin;
      ERROR 1253 (42000): COLLATION 'latin2_bin' is not valid
      for CHARACTER SET 'latin1'
 

Info Catalog

(mysql.info) charset-collate-tricky

(mysql.info) charset-collations

(mysql.info) charset-collation-effect