Oracle 5.0, Справочное руководство

Страница: 825 / 3232

Adding a Character Set
805
You can select which language the server uses for error messages using the instructions in this
section.
To start
mysqld
with a particular language for error messages, use the
--language
[410] or
-
L
option. The option value can be a language name or the full path to the error message file. For
example:
shell> mysqld --language=swedish
Or:
shell> mysqld --language=/usr/local/share/swedish
The language name should be specified in lowercase.
By default, the language files are located in the
share/mysql/LANGUAGE
directory under the MySQL
base directory.
For information about changing the character set for error messages (rather than the language), see
Section 10.1.6, “Character Set for Error Messages” .
You can change the content of the error messages produced by the server using the instructions in
the MySQL Internals manual, available at
MySQL Internals: Error Messages . If you do change the
content of error messages, remember to repeat your changes after each upgrade to a newer version of
MySQL.
10.3. Adding a Character Set
This section discusses the procedure for adding a character set to MySQL. The proper procedure
depends on whether the character set is simple or complex:
• If the character set does not need special string collating routines for sorting and does not need
multi-byte character support, it is simple.
• If the character set needs either of those features, it is complex.
For example,
greek
and
swe7
are simple character sets, whereas
big5
and
czech
are complex
character sets.
To use the following instructions, you must have a MySQL source distribution. In the instructions,
MYSET
represents the name of the character set that you want to add.
1. Add a
<charset>
element for
MYSET
to the
sql/share/charsets/Index.xml
file. Use the
existing contents in the file as a guide to adding new contents. A partial listing for the
latin1
<charset>
element follows:
<charset name="latin1">
<family>Western</family>
<description>cp1252 West European</description>
...
<collation name="latin1_swedish_ci" id="8" order="Finnish, Swedish">
<flag>primary</flag>
<flag>compiled</flag>
</collation>
<collation name="latin1_danish_ci" id="15" order="Danish"/>
...
<collation name="latin1_bin" id="47" order="Binary">
<flag>binary</flag>
<flag>compiled</flag>
</collation>
...
</charset>
The
<charset>
element must list all the collations for the character set. These must include at
least a binary collation and a default (primary) collation. The default collation is often named using