MySQL Bugs: #22008: [Request] Myanmar Collation Extension for UCS and UTF8

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:	Windows (Linux/Windows)
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	complex script collation, Contribution, Localization, Myanmar, south east asian script

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

Thank you for a reasonable feature request.

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?

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.

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.

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.

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.

myanmar collation.

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

character set file

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

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 !

SCA has been received and approved. Thank you!

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

Can I try it again with CLDR Collation? Which version is suitable for customize collation?

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.

Bug #68068 was marked as duplicate of this one.

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.

Burmese Sorting screenshot in MySQL WorkBench

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

Note that there are currently no official plans to implement this in upcoming versions.

Dear Erlend Dahl,
Any how, we would keep maintain by community. Thanks for your prompt reply.
Best
--NT