(mysql.info) charset-collation-effect

Info Catalog

(mysql.info) charset-collation-charset

(mysql.info) charset-collations

 
 10.5.6 An Example of the Effect of Collation
 --------------------------------------------
 
 Suppose that column `X' in table `T' has these `latin1' column values:
 
      Muffler
      Mu"ller
      MX Systems
      MySQL
 
 And suppose that the column values are retrieved using the following
 statement:
 
      SELECT X FROM T ORDER BY X COLLATE COLLATION_NAME;
 
 The following table shows the resulting order of the values if we use
 `ORDER BY' with different collations:
 
 `latin1_swedish_ci'    `latin1_german1_ci'    `latin1_german2_ci'
 Muffler                Muffler                Mu"ller
 MX Systems             Mu"ller                Muffler
 Mu"ller                MX Systems             MX Systems
 MySQL                  MySQL                  MySQL
 
 The character that causes the different sort orders in this example is
 the U with two dots over it (`u"'), which the Germans call `U-umlaut.'
 
    * The first column shows the result of the `SELECT' using the
      Swedish/Finnish collating rule, which says that U-umlaut sorts
      with Y.
 
    * The second column shows the result of the `SELECT' using the
      German DIN-1 rule, which says that U-umlaut sorts with U.
 
    * The third column shows the result of the `SELECT' using the German
      DIN-2 rule, which says that U-umlaut sorts with UE.
 

Info Catalog

(mysql.info) charset-collation-charset

(mysql.info) charset-collations