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