Difference between revisions of "MySQL collation for Kyrgyz"
From FireSpeakerWiki
Jump to navigationJump to searchFirespeaker (talk | contribs) (Created page with '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...') |
Firespeaker (talk | contribs) |
||
Line 21: | Line 21: | ||
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. | 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]] |
Revision as of 03:17, 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:
<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.