| 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: | |
| 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
[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)
