MySQL collation for Kyrgyz - Revision history

Firespeaker at 17:35, 12 May 2010

2010-05-12T17:35:26Z

← Older revision		Revision as of 17:35, 12 May 2010
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]]		[[Category:Kyrgyz]]

Firespeaker: нңо, not ноң

2009-12-31T08:49:02Z

нңо, not ноң

← Older revision		Revision as of 08:49, 31 December 2009
Line 7:		Line 7:
	<collation name="utf8_cyr_kir" id="244">		<collation name="utf8_cyr_kir" id="244">
	<rules>		<rules>
	<reset before="primary">\~~u043E~~</reset>		<reset before="primary">\u04A3</reset>
	<p>\~~u04A3~~</p>		<p>\u043E</p>
	<reset before="primary">\u043F</reset>		<reset before="primary">\u043F</reset>
	<p>\u04E9</p>		<p>\u04E9</p>

Firespeaker at 08:29, 8 November 2009

2009-11-08T08:29:16Z

← Older revision		Revision as of 08:29, 8 November 2009
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">

Firespeaker at 08:17, 8 November 2009

2009-11-08T08:17:12Z

← Older revision		Revision as of 08:17, 8 November 2009
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]]

Firespeaker: 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...'

2009-11-08T08:09:47Z

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...'

New page

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:
<pre>
<charset name="utf8">
...
<collation name="utf8_cyr_kir" id="244">
<rules>
<reset before="primary">\u043E</reset>
\u04A3
<reset before="primary">\u043F</reset>
\u04E9
<reset before="primary">\u0444</reset>
\u04AF
<reset before="primary">\u0451</reset>
\u0435
</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.