5.10.1.1. Using the German Character Set
In MySQL 5.1, character set and collation are
specified separately. This means that if you want German sort
order, you should select the latin1
character set and either the
latin1_german1_ci or
latin1_german2_ci collation. For example,
to start the server with the
latin1_german1_ci collation, use the
--character-set-server=latin1 and
--collation-server=latin1_german1_ci options.
For information on the differences between these two
collations, see Section 10.9.2, “West European Character Sets”.
