Bug #4745 Add Vietnamese collation for the ucs2 and utf8 Unicode character sets
Submitted: 25 Jul 2004 12:54 Modified: 19 Mar 2008 14:01
Reporter: Quan Nguyen
Status: Verified
Category:Server: Charsets Severity:S4 (Feature request)
Version:any OS:Any (All)
Assigned to: Alexander Barkov Target Version:
Triage: Needs Triage: D5 (Feature request)

File: Maximum allowed size is 500KB.
Description:
Privacy:

If the data you need to attach is more than 500KB, you should create a compressed archive of the data and a README file that describes the data with a filename that includes the bug number (example: bug-data-4745.zip), and use FTP to upload the archive to ftp://ftp.mysql.com/pub/mysql/upload/. Once you have uploaded the file, add a comment to this bug to notify us about it. Note: This directory is unlistable, which means that once you have uploaded your file, you will not be able to see it.

All entries become the exclusive editorial property of Sun Microsystems, Inc.

[5 Jul 2007 2:32] Peter Gulutzan
Instructions for adding a new Unicode collation

Attachment: vietnamese.txt (text/plain), 19.87 KiB.

[3 Aug 2007 5:35] Quan Nguyen
Index.xml containing complete Vietnamese collation

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

[3 Aug 2007 5:36] Quan Nguyen
Sample table with Vietnamese characters in correct order

Attachment: vi_collate.sql (application/octet-stream, text), 4.17 KiB.

[3 Aug 2007 5:39] Quan Nguyen
Incorrect results from experimental vi collation

Attachment: vi_abc.csv (application/vnd.ms-excel, text), 1.76 KiB.

[3 Aug 2007 8:40] Alexander Barkov
"SELECT id,letter ORDER BY letter" - MySQL-5.0.46

Attachment: vi-5.0.46.csv (application/octet-stream, text), 1.21 KiB.

[3 Aug 2007 8:41] Alexander Barkov
"SELECT GROUP_CONCAT(letter) FROM letters GROUP BY letter"  - MySQL 5.0.46

Attachment: vi-gconcat-5.0.46.txt (text/plain), 617 bytes.

[7 Aug 2007 8:24] Alexander Barkov
A fixed version of the "GCONCAT" query

Attachment: vi-gconcat2.txt (text/plain), 610 bytes.

[30 Sep 2007 17:34] Quan Nguyen
Added a second Vietnamese collation for use with overriding COLLATE clause

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

[20 Nov 2007 3:07] Quan Nguyen
Here we go.

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