(mysql.info.gz) German character set
Info Catalog
(mysql.info.gz) Character sets
(mysql.info.gz) Character sets
5.8.1.1 Using the German Character Set
......................................
In MySQL 4.0, to get German sorting order, you should start `mysqld'
with a `--default-character-set=latin1_de' option. This affects server
behavior in several ways:
* When sorting and comparing strings, the following mapping is
performed on the strings before doing the comparison:
a" -> ae
o" -> oe
u" -> ue
ss -> ss
* All accented characters are converted to their unaccented uppercase
counterpart. All letters are converted to uppercase.
* When comparing strings with `LIKE', the one-character to
two-character mapping is not done. All letters are converted to
uppercase. Accents are removed from all letters except `U"', `u"',
`O"', `o"', `A"', and `a"'.
In MySQL 4.1 and up, character set and collation are specified
separately. 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
Charset-we-sets.
Info Catalog
(mysql.info.gz) Character sets
(mysql.info.gz) Character sets
automatically generated byinfo2html