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]
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.