Adding a Character Set desired locale name. For example, if the server is using the  fr_FR  locale for error messages, a client can execute this statement to receive error messages in English: SET lc_messages = ’en_US’; 10.13 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: For example,  greek  and  swe7  are simple character sets, whereas  big5  and  czech  are complex character sets. •If the character set does not need special string collating routines for sorting and does not need multibyte character support, it is simple. •If the character set needs either of those features, it is complex. 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 a suffix of general_ci  (general, case-insensitive). It is possible for the binary collation to be the default collation, but usually they are different. The default collation should have a  primary  flag. The binary collation should have a  binary  flag. You must assign a unique ID number to each collation. The range of IDs from 1024 to 2047 is reserved for user-defined collations. To find the maximum of the currently used collation IDs, use this query: SELECT MAX(ID) FROM INFORMATION_SCHEMA.COLLATIONS; 2. This step depends on whether you are adding a simple or complex character set. A simple character set requires only a configuration file, whereas a complex character set requires C source file that defines collation functions, multibyte functions, or both. For a simple character set, create a configuration file,  MYSET .xml , that describes the character set properties. Create this file in the  sql/share/charsets  directory. You can use a copy of latin1.xml  as the basis for this file. The syntax for the file is very simple: 1988