When sorting and comparing strings, the following mapping is performed on the strings before doing the comparison:
ä -> ae ö -> oe ü -> ue ß -> ss
All accented characters are converted to their unaccented uppercase counterpart. All letters are converted to uppercase.
When comparing strings with
the one-character to two-character mapping is not done. All
letters are converted to uppercase. Accents are removed from
all letters except
In MySQL 4.1 and up, character set and collation are specified
separately. You should select the
character set and either the
latin1_german2_ci collation. For example, to
start the server with the
collation, use the
For information on the differences between these two collations, see Section 18.104.22.168, “West European Character Sets”.