From: Date: January 25 2007 9:08pm
Subject: Patch to add Sinhala (Sri Lanka) collation to MySQL
List-Archive: http://lists.mysql.com/internals/34270
Message-Id: <1169755687.17722.7.camel@localhost>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Hi,

1) Here's a patch to add Sinhala (Sri Lanka) collation to MySQL.

Patch
=====
http://cvs.savannah.nongnu.org/viewcvs/*checkout*/sinhala/patches/mysql-dfsg-5.0-5.0.27-sinhala1.patch?root=sinhala


Testcase
========
http://cvs.savannah.nongnu.org/viewcvs/*checkout*/sinhala/patches/mysql-data-sinhala.txt?root=sinhala


Testcase output
===============
http://cvs.savannah.nongnu.org/viewcvs/*checkout*/sinhala/patches/mysql-output-utf8_sinhala_ci.txt?root=sinhala


2) ICU Collation Customization (tailorings)

In strings/ctype-uca.c it is mentioned that the collation syntax is
based on a subset of the ICU tailoring syntax:

http://icu.sourceforge.net/userguide/Collate_Customization.html

However, I'm wondering if MySQL implements this particular property:

2. [ & a < b < c < d , & c < m ] => [ & a < b < c < m < d ]

The impression I have is that it currently doesn't increment the weights
of the letters that follow the newly inserted letter.

BTW, I'm not on the mailing list so please keep my email address as a
recipient.

cya,
#