Bug #4745 Add Vietnamese collation for the ucs2 and utf8 Unicode character sets
Submitted: 25 Jul 2004 10:54 Modified: 29 Jul 2010 13:39
Reporter: Quan Nguyen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Charsets Severity:S4 (Feature request)
Version:any OS:Any (All)
Assigned to: Alexander Barkov CPU Architecture:Any

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

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

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

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

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

[3 Aug 2007 3: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 3:39] Quan Nguyen
Incorrect results from experimental vi collation

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

[3 Aug 2007 6: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 6: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 6:24] Alexander Barkov
A fixed version of the "GCONCAT" query

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

[30 Sep 2007 15: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 2:07] Quan Nguyen
Here we go.

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