Bug #26474 Add Sinhala script (Sri Lanka) collation to MySQL
Submitted: 19 Feb 2007 7:34 Modified: 9 Oct 2007 22:07
Reporter: Harshula Jayasuriya
Status: Closed
Category:Server: Charsets Severity:S4 (Feature request)
Version:5.0-community OS:Any
Assigned to: Bugs System Target Version:
Tags: Sinhala, collation, Contribution
Triage: D5 (Feature request)

[19 Feb 2007 7:34] Harshula Jayasuriya
Description:
MySQL currently only has the facility to collate the Sinhala script (Sri Lanka) using the
Default Unicode Collation Element Table (DUCET) or the Unicode binary order.

A standard Sinhala collation order has been established as part of SLS1134 (SCCII Part 1
: Collation Sequence). I've created a patch to add the required tailoring rules to MySQL
for it to support the standard Sinhala collation order.

Initial email:
http://lists.mysql.com/internals/34270

I'll attach the patch and testcase.

Regards,
Harshula

How to repeat:
Refer to the description.
[19 Feb 2007 9:21] Harshula Jayasuriya
Patch to add Sinhala script collation

Attachment: mysql-dfsg-5.0-5.0.27-sinhala1.patch (text/x-patch), 6.88 KiB.

[1 Mar 2007 14:21] Harshula Jayasuriya
Patch to add a Sinhala collation test to the test suite

Attachment: mysql-dfsg-5.0-5.0.32-sinhala2.patch (text/x-patch), 3.77 KiB.

[1 Mar 2007 14:52] Miguel Solorzano
Thank you for the bug report and contribution.
[21 Apr 2007 8:32] Harshula Jayasuriya
Hi,

Is there anything else MySQL would like me to provide in order to get this patch
checked in.

BTW, additional discussion here:
http://lists.mysql.com/internals/34379

Regards,
Harshula
[30 May 2007 20:08] Harshula Jayasuriya
Provide the testcase patch in the format requested.

Attachment: mysql-dfsg-5.0-5.0.38-sinhala2.patch (text/x-diff), 5.09 KiB.

[8 Jun 2007 8:36] Alexander Barkov
From technical point of view, the patch is ok to push.
[8 Jun 2007 15:59] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/28402

ChangeSet@1.2474, 2007-06-08 09:57:36-04:00, cmiller@zippy.cornsilk.net +5 -0
  Contributed patch from Harshula Jayasuriya,  CLA signed 21 Feb 2007.
  
  Bug#26474: Add Sinhala script collation
  
  The Default Unicode Collation Element Table (DUCET) and the Unicode 
  binary order are insufficient to properly sort Sinhala script.
  
  A standard Sinhala collation order has been established as part of 
  SLS1134 (SCCII Part 1 : Collation Sequence).
[8 Jun 2007 16:07] Chad MILLER
Queued to 5.2-maint tree.
[22 Jun 2007 21:44] Trudy Pelzer
See also WL#3764 Sinhala Collation
[5 Jul 2007 17:34] Chad MILLER
In 5.2.4-alpha.
[31 Aug 2007 0:00] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/33482

ChangeSet@1.2591, 2007-08-30 15:32:18-06:00, tsmith@ramayana.hindu.god +5 -0
  Contributed patch from Harshula Jayasuriya,  CLA signed 21 Feb 2007.
  
  Bug#26474: Add Sinhala script collation
  
  The Default Unicode Collation Element Table (DUCET) and the Unicode 
  binary order are insufficient to properly sort Sinhala script.
  
  A standard Sinhala collation order has been established as part of 
  SLS1134 (SCCII Part 1 : Collation Sequence).
[31 Aug 2007 0:42] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/33487

ChangeSet@1.2591, 2007-08-30 16:41:07-06:00, tsmith@ramayana.hindu.god +5 -0
  Contributed patch from Harshula Jayasuriya,  CLA signed 21 Feb 2007.
  
  Bug#26474: Add Sinhala script collation
  
  The Default Unicode Collation Element Table (DUCET) and the Unicode 
  binary order are insufficient to properly sort Sinhala script.
  
  A standard Sinhala collation order has been established as part of 
  SLS1134 (SCCII Part 1 : Collation Sequence).
[31 Aug 2007 9:34] Timothy Smith
This patch never actually made it to 5.2.  It's now queued in the mysql-5.2-maint tree,
and will soon be merged up.
[4 Sep 2007 20:57] Timothy Smith
Pushed to MySQL 5.2.6-alpha.
[9 Oct 2007 22:07] Paul DuBois
Noted in 5.2.6 changelog.

Sinhala collations utf8_sinhala_ci and ucs2_sinhala_ci were added for
the utf8 and ucs2 character sets.