Chapter 4: Database Administration 311 [client]
character-sets-dir=/usr/local/mysql/share/mysql/charsets
where the path points to the directory in which the dynamic MySQL character sets are
stored.
One can force the client to use specific character set by specifying:
[client]
default-character-set=character-set-name
but normally this is never needed. 4.7.1.1 German character set To get German sorting order, you should start mysqld with --default-character-
set=latin1_de. This will give you the following characteristics.
When sorting and comparing strings, the following mapping is done on the strings before
doing the comparison:
( a -> ae ( o -> oe ( u -> ue _ -> ss All accented characters, are converted to their un-accented uppercase counterpart. All
letters are converted to uppercase.
When comparing strings with LIKE the one -> two character mapping is not done. All
letters are converted to uppercase. Accent are removed from all letters except: (
U, (u, ( O, (o, ( A and (a. 4.7.2 Non-English Error Messages mysqld can issue error messages in the following languages: Czech, Danish, Dutch, English
(the default), Estonian, French, German, Greek, Hungarian, Italian, Japanese, Korean,
Norwegian, Norwegian-ny, Polish, Portuguese, Romanian, Russian, Slovak, Spanish, and
Swedish.
To start mysqld with a particular language, use either the --language=lang or -L lang
options. For example:
shell> mysqld --language=swedish or: shell> mysqld --language=/usr/local/share/swedish Note that all language names are specified in lowercase.
The language files are located (by default) in `mysql_base_dir /share/LANGUAGE /'.
To update the error message file, you should edit the `errmsg.txt' file and execute the
following command to generate the `errmsg.sys' file:
shell> comp_err errmsg.txt errmsg.sys If you upgrade to a newer version of MySQL, remember to repeat your changes with the
new `errmsg.txt' file.

Web Hosting by Oxxus.Net

manual-1001.html 
manual-1003.html