(mysql.info.gz) German character set

 
 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
automatically generated byinfo2html