Bug #26474 Add Sinhala script (Sri Lanka) collation to MySQL
Submitted: 19 Feb 2007 6:34 Modified: 20 Nov 2010 0:05
Reporter: Harshula Jayasuriya Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Charsets Severity:S4 (Feature request)
Version:5.0-community OS:Any
Assigned to: Chad MILLER CPU Architecture:Any
Tags: collation, Contribution, Sinhala

[19 Feb 2007 6: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 8: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 13: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 13:52] MySQL Verification Team
Thank you for the bug report and contribution.
[21 Apr 2007 6: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 18: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 6:36] Alexander Barkov
From technical point of view, the patch is ok to push.
[8 Jun 2007 13: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 14:07] Chad MILLER
Queued to 5.2-maint tree.
[22 Jun 2007 19:44] Trudy Pelzer
See also WL#3764 Sinhala Collation
[5 Jul 2007 15:34] Chad MILLER
In 5.2.4-alpha.
[30 Aug 2007 22: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).
[30 Aug 2007 22: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 7: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 18:57] Timothy Smith
Pushed to MySQL 5.2.6-alpha.
[9 Oct 2007 20: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.
[19 Oct 2010 7:52] MySQL Verification Team
just noting for self reference this error: 

mysql> set names utf8 collate utf8_sinhala_ci ;
ERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of 'utf8'

mysql> select version();
+-----------------------------+
| version()                   |
+-----------------------------+
| 5.5.8-rc-valgrind-max-debug |
+-----------------------------+
1 row in set (0.00 sec)
[9 Nov 2010 8:23] 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/123183

3106 Alexander Barkov	2010-11-09
      Postfix for Bug#26474 Add Sinhala script (Sri Lanka) collation to MySQL
[9 Nov 2010 8:28] Alexander Barkov
Post-fix pushed into mysql-5.5-bugteam [5.5.8]
[9 Nov 2010 10:41] MySQL Verification Team
Bar, will this fix need an amendment in CHECK TABLE FOR UPGRADE code?
[9 Nov 2010 10:52] Alexander Barkov
Shane, no CHECK FOR UPGRADE is needed.
[13 Nov 2010 16:04] Bugs System
Pushed into mysql-trunk 5.6.99-m5 (revid:alexander.nozdrin@oracle.com-20101113155825-czmva9kg4n31anmu) (version source revid:alexander.nozdrin@oracle.com-20101113152450-2zzcm50e7i4j35v7) (merge vers: 5.6.1-m4) (pib:21)
[13 Nov 2010 16:28] Bugs System
Pushed into mysql-next-mr (revid:alexander.nozdrin@oracle.com-20101113160336-atmtmfb3mzm4pz4i) (version source revid:alexander.nozdrin@oracle.com-20101113152540-gxro4g0v29l27f5x) (pib:21)
[14 Nov 2010 3:00] Paul DuBois
Noted in 5.5.8 changelog.

SET NAMES utf8 COLLATE utf8_sinhala_ci did not work.
[16 Dec 2010 22:25] Bugs System
Pushed into mysql-5.5 5.5.9 (revid:jonathan.perkin@oracle.com-20101216101358-fyzr1epq95a3yett) (version source revid:jonathan.perkin@oracle.com-20101216101358-fyzr1epq95a3yett) (merge vers: 5.5.9) (pib:24)