View source for MySQL collation for Kyrgyz

This page provides a UCA collation for Kyrgyz in mysql.  The UCA itself was built using [http://dev.mysql.com/doc/refman/5.0/en/adding-collation-unicode-uca.html guidelines found on mysql's webiste], links from there, and some bugging of people on IRC (thanks), and a certain amount of experimenting.

The collation should go in the unicode character set definition in /usr/share/mysql/charsets/Index.xml:
<pre>
<charset name="utf8">
  ...
  <collation name="utf8_cyr_kir" id="244">
    <rules>
      <reset before="primary">\u04A3</reset>
      <p>\u043E</p>
      <reset before="primary">\u043F</reset>
      <p>\u04E9</p>
      <reset before="primary">\u0444</reset>
      <p>\u04AF</p>
      <reset before="primary">\u0451</reset>
      <p>\u0435</p>
    </rules>
  </collation>
</charset>
</pre>

The id can be anything from 0 to 255, but it should be unique.  The mysql process will have to be restarted after modifying the file.  The collation can then be applied to a table.

[[Category:Kyrgyz]]