| 1 |
--source suite/collations/include/unicode.inc |
| 2 |
insert into unicode values (0x100001,'GH','Vietnamese GH','Lu'); |
| 3 |
insert into unicode values (0x100002,'Gh','Vietnamese Gh','Lt'); |
| 4 |
insert into unicode values (0x100003,'gh','Vietnamese gh','Ll'); |
| 5 |
insert into unicode values (0x100004,'GI','Vietnamese GI','Lu'); |
| 6 |
insert into unicode values (0x100005,'Gi','Vietnamese Gi','Lt'); |
| 7 |
insert into unicode values (0x100006,'gi','Vietnamese gi','Ll'); |
| 8 |
insert into unicode values (0x100007,'KH','Vietnamese KH','Lu'); |
| 9 |
insert into unicode values (0x100008,'Kh','Vietnamese Kh','Lt'); |
| 10 |
insert into unicode values (0x100009,'kh','Vietnamese kh','Ll'); |
| 11 |
insert into unicode values (0x10000A,'NH','Vietnamese NH','Lu'); |
| 12 |
insert into unicode values (0x10000B,'Nh','Vietnamese Nh','Lt'); |
| 13 |
insert into unicode values (0x10000C,'nh','Vietnamese nh','Ll'); |
| 14 |
insert into unicode values (0x10000D,'NG','Vietnamese NG','Lu'); |
| 15 |
insert into unicode values (0x10000E,'Ng','Vietnamese Ng','Lt'); |
| 16 |
insert into unicode values (0x10000F,'ng','Vietnamese ng','Ll'); |
| 17 |
insert into unicode values (0x100010,'NGH','Vietnamese NGH','Lu'); |
| 18 |
insert into unicode values (0x100011,'Ngh','Vietnamese Ngh','Lt'); |
| 19 |
insert into unicode values (0x100012,'ngh','Vietnamese ngh','Ll'); |
| 20 |
insert into unicode values (0x100013,'PH','Vietnamese PH','Lu'); |
| 21 |
insert into unicode values (0x100014,'Ph','Vietnamese Ph','Lt'); |
| 22 |
insert into unicode values (0x100015,'ph','Vietnamese ph','Ll'); |
| 23 |
insert into unicode values (0x100016,'QU','Vietnamese QU','Lu'); |
| 24 |
insert into unicode values (0x100017,'Qu','Vietnamese Qu','Lt'); |
| 25 |
insert into unicode values (0x100018,'qu','Vietnamese qu','Ll'); |
| 26 |
insert into unicode values (0x100019,'TH','Vietnamese TH','Lu'); |
| 27 |
insert into unicode values (0x10001A,'Th','Vietnamese Th','Lt'); |
| 28 |
insert into unicode values (0x10001B,'th','Vietnamese th','Ll'); |
| 29 |
insert into unicode values (0x10001C,'TR','Vietnamese TR','Lu'); |
| 30 |
insert into unicode values (0x10001D,'Tr','Vietnamese Tr','Lt'); |
| 31 |
insert into unicode values (0x10001E,'tr','Vietnamese tr','Ll'); |
| 32 |
select hex(convert(uc using utf32)), hex(weight_string(convert(uc using utf8mb4) collate utf8mb4_vi_0900_ai_ci)), name from unicode where category in ('Lu','Ll','Lt','Lm') order by uc collate utf8mb4_vi_0900_ai_ci, cp; |
| 33 |
select hex(convert(uc using utf32)), hex(weight_string(convert(uc using utf8mb4) collate utf8mb4_vi_0900_as_cs)), name from unicode where category in ('Lu','Ll','Lt','Lm') order by uc collate utf8mb4_vi_0900_as_cs, cp; |
| 34 |
drop table if exists unicode; |