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) |
||
(3 intermediate revisions by the same user not shown) | |||
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"> | ||
Line 7: | Line 7: | ||
<collation name="utf8_cyr_kir" id="244"> | <collation name="utf8_cyr_kir" id="244"> | ||
<rules> | <rules> | ||
− | <reset before="primary">\ | + | <reset before="primary">\u04A3</reset> |
− | <p>\ | + | <p>\u043E</p> |
<reset before="primary">\u043F</reset> | <reset before="primary">\u043F</reset> | ||
<p>\u04E9</p> | <p>\u04E9</p> | ||
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. | ||
+ | |||
+ | For reference, the characters translate as follows: | ||
+ | |||
+ | {|class="wikitable" | ||
+ | |- | ||
+ | ! reference || = || →before || = | ||
+ | |- | ||
+ | | u04A3 || ң || u043E || о | ||
+ | |- | ||
+ | | u043F || п || u04E9 || ө | ||
+ | |- | ||
+ | | u0444 || ф || u04AF|| ү | ||
+ | |- | ||
+ | | u0451 || ё || u0435 || е | ||
+ | |} | ||
+ | |||
+ | [[Category:Kyrgyz]] |
Latest revision as of 12:35, 12 May 2010
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">\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>
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.
For reference, the characters translate as follows:
reference | = | →before | = |
---|---|---|---|
u04A3 | ң | u043E | о |
u043F | п | u04E9 | ө |
u0444 | ф | u04AF | ү |
u0451 | ё | u0435 | е |