Adding a Simple Collation to an 8-Bit Character Set +---------+ | MAX(ID) | +---------+ | 247 | +---------+ mysql>  SELECT ID FROM INFORMATION_SCHEMA.COLLATIONS ORDER BY ID; +-----+ | ID | +-----+ | 1 | | 2 | | ... | | 52 | | 53 | | 57 | | 58 | | ... | | 98 | | 99 | | 128 | | 129 | | ... | | 247 | +-----+ 1996 <charset name="latin1"> ... <collation name="latin1_test_ci" id="1024"/> ... To display a list of all currently used IDs, issue this statement: Before upgrading, you should save the configuration files that you change. If you upgrade in place, the process replaces the modified files. This section describes how to add a simple collation for an 8-bit character set by writing the  <collation> elements associated with a  <charset>  character set description in the MySQL  Index.xml  file. The procedure described here does not require recompiling MySQL. The example adds a collation named latin1_test_ci  to the  latin1  character set. mysql>  SHOW VARIABLES LIKE ’character_sets_dir’; +--------------------+-----------------------------------------+ | Variable_name | Value | +--------------------+-----------------------------------------+ | character_sets_dir | /user/local/mysql/share/mysql/charsets/ | +--------------------+-----------------------------------------+ 3. Choose a name for the collation and list it in the  Index.xml  file. Find the  <charset>  element for the character set to which the collation is being added, and add a  <collation>  element that indicates the collation name and ID, to associate the name with the ID. For example: 2. Modify the  Index.xml  and  latin1.xml  configuration files. These files are located in the directory named by the  character_sets_dir  system variable. You can check the variable value as follows, although the path name might be different on your system: 1. Choose a collation ID, as shown in Section 10.14.2, “Choosing a Collation ID” . The following steps use an ID of 1024. Warning 10.14.3 Adding a Simple Collation to an 8-Bit Character Set