Bug #22008 [Request] Myanmar Collation Extension for UCS and UTF8
Submitted: 5 Sep 2006 6:52 Modified: 11 Jan 2013 13:36
Reporter: Ngwe Tun (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Charsets Severity:S2 (Serious)
Version:5.4 OS:Microsoft Windows (Linux/Windows)
Assigned to: Assigned Account CPU Architecture:Any
Tags: complex script collation, Contribution, Localization, Myanmar, south east asian script
Triage: Triaged: D5 (Feature request)

[5 Sep 2006 6:52] Ngwe Tun
Description:
Dear Folks

Actually, we really needed complex script sorting (collation) supports in MySQL. We are strongly hoping to get most of language and internationalization supports in MySQL DBMS.

Thanks in advance.

How to repeat:
Please be there at 
http://developer.mimer.com/charts/myanmar.htm and some tailoring codes are http://developer.mimer.com/charts/myanmar.txt 

Technical data is available at http://www.thanlwinsoft.org/ThanLwinSoft/MyanmarUnicode/Sorting/MyanmarCollation.pdf

http://www.thanlwinsoft.org/ThanLwinSoft/Downloads/Collation/myCollate20041213.tar.gz
[5 Sep 2006 10:40] Valeriy Kravchuk
Thank you for a reasonable feature request.
[16 Aug 2007 19:11] Peter Gulutzan
Recently, in response to requests from the Vietnamese community,
Bug#4745 Add Vietnamese collation for the ucs2 and utf8 Unicode character sets
we wrote an article about adding collations, with Vietnamese examples:

http://bugs.mysql.com/file.php?id=6814

We're sorry for a mistake in the article:
"The second method "ADDING A NEW COLLATION BY CHANGING THE MARKUP FILE"
works only starting from 5.0.46. The patch was delayed for some reasons.
5.0.46 will be available soon."

Is it possible to use the methods described in the article,
applying (of course) Myanmar rules?
[17 Nov 2007 10:38] Ngwe Tun
Dear Peter,

I would like to know about customization of collation will succeed in 5.1, 5.2 and 6.0 instead of 5.0.46.

Today, I got news letter, there are too many enhancement in new releases. But MySQL 5.0 still in 5.0.45 in downloads section of mysql.com

I'm looking forward to your reply.

Ngwe Tun.
[17 Nov 2007 23:14] Peter Gulutzan
The methods described in the WL#4745 comment will work with
a recent MySQL 5.1 download. They should be okay with 6.0
as well, although I haven't tested that personally.
[21 Apr 2008 11:27] Ngwe Tun
as per collation customization guide line. I've tried mysql 5.1. But It's not succeeded as screen shots. Let me have direction to fix it.

Or Still mysql not supported well in collation customization. I attached Index.xml file too.

Cheers.
[8 Sep 2009 18:36] Ngwe Tun
I've tried My SQL Server 5.4,

It's still unknown collate yet.

How can I fix it. Please see my current works in attachment.

Thanks.
[8 Sep 2009 18:36] Ngwe Tun
myanmar collation.

Attachment: mysql.xml (text/xml), 37.65 KiB.

[8 Sep 2009 18:37] Ngwe Tun
character set file

Attachment: Index.xml (text/xml), 93.14 KiB.

[23 Mar 2010 10:43] Lenz Grimmer
Hello Ngwe,

I apologize for the late reply. Thank you very much for your contribution!

In order for us to continue the process of reviewing your contribution to MySQL - We need you to review and sign the Sun|MySQL contributor agreement (the "SCA")

The process is explained here: 
http://forge.mysql.com/wiki/Sun_Contributor_Agreement

Getting a signed/approved SCA on file will help us facilitate your contribution -- this one, and others in the future.

Please let me know if you need any assistance with this.

Thank you !
[24 Mar 2010 11:47] Lenz Grimmer
SCA has been received and approved. Thank you!
[16 Oct 2010 10:48] Alexander Barkov
The collation described in Index.xml 
resembles exactly Myanmar collation in Unicode's Common Locale Data Repository (CLDR):

http://unicode.org/cldr/trac/browser/trunk/common/collation/my.xml
[17 Oct 2010 15:19] Ngwe Tun
Can I try it again with CLDR Collation? Which version is suitable for customize collation?
[18 Oct 2010 9:35] Alexander Barkov
Hi Ngwe,

Unfortunately, MySQL collation customization code is missing some
features required for Myanmar.

- It does not support things like "\u1005\u1031\u102C\u103A"
  (i.e. contractions consisting of 3 or 4 letters).
  MySQL currently supports only contractions consisting of 2 letters.

- Tailoring size is limited to 1 Kb, which is not enough for Myanmar.

We'll try to address both problems soon.
[11 Jan 2013 12:59] Sveta Smirnova
Bug #68068 was marked as duplicate of this one.
[11 Jan 2013 13:29] Ngwe Tun
I've tried to replace Index.xml in MySQL 5.6.7 on MAC OS X. It does work correctly. Here is screen-shot on MAC OS X. I already tried on Linux and Windows too. cheers.
[11 Jan 2013 13:31] Ngwe Tun
Burmese Sorting screenshot in MySQL WorkBench

Attachment: Burmese_Sorting.tiff (image/tiff, text), 251.53 KiB.

[11 Jan 2013 13:33] Erlend Dahl
Note that there are currently no official plans to implement this in upcoming versions.
[11 Jan 2013 13:36] Ngwe Tun
Dear Erlend Dahl,
Any how, we would keep maintain by community. Thanks for your prompt reply.
Best
--NT