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] Shane Bester
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] Shane Bester
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)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.096 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.