10.5.6. An Example of the Effect of Collation
Suppose that column X in table
T has these latin1 column
values:
Muffler
Mü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:
The character that causes the different sort orders in this
example is the U with two dots over it
(ü), 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.
