MySQL collation for Kyrgyz: Difference between revisions
From FirespeakerWiki
Jump to navigationJump to search
Firespeaker (talk | contribs) No edit summary |
Firespeaker (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
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. | 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: | The collation should go in the unicode character set definition in /usr/share/mysql/charsets/Index.xml: | ||
<pre> | <pre> | ||
<charset name="utf8"> | <charset name="utf8"> | ||
Revision as of 08:29, 8 November 2009
This page provides a UCA collation for Kyrgyz in mysql. The UCA itself was built using 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:
<charset name="utf8">
...
<collation name="utf8_cyr_kir" id="244">
<rules>
<reset before="primary">\u043E</reset>
<p>\u04A3</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>
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.
