| 1 |
--source suite/collations/include/unicode.inc |
| 2 |
insert into unicode values (0x100001,'CH','Galician CH','Lu'); |
| 3 |
insert into unicode values (0x100002,'Ch','Galician Ch','Lt'); |
| 4 |
insert into unicode values (0x100003,'ch','Galician ch','Ll'); |
| 5 |
insert into unicode values (0x100004,'LL','Galician LL','Lu'); |
| 6 |
insert into unicode values (0x100005,'Ll','Galician Ll','Lt'); |
| 7 |
insert into unicode values (0x100006,'ll','Galician ll','Ll'); |
| 8 |
select hex(convert(uc using utf32)), hex(weight_string(convert(uc using utf8mb4) collate utf8mb4_gl_0900_ai_ci)), name from unicode where category in ('Lu','Ll','Lt','Lm') order by uc collate utf8mb4_gl_0900_ai_ci, cp; |
| 9 |
select hex(convert(uc using utf32)), hex(weight_string(convert(uc using utf8mb4) collate utf8mb4_gl_0900_as_cs)), name from unicode where category in ('Lu','Ll','Lt','Lm') order by uc collate utf8mb4_gl_0900_as_cs, cp; |
| 10 |
drop table if exists unicode; |