| 1 |
--source suite/collations/include/unicode.inc |
| 2 |
|
| 3 |
insert into unicode values |
| 4 |
(0x30001, _utf32 0x30001, 'In Plane 3', 'Cn'), |
| 5 |
(0x40001, _utf32 0x40001, 'In Plane 4', 'Cn'), |
| 6 |
(0x50001, _utf32 0x50001, 'In Plane 5', 'Cn'), |
| 7 |
(0x60001, _utf32 0x60001, 'In Plane 6', 'Cn'), |
| 8 |
(0x70001, _utf32 0x70001, 'In Plane 7', 'Cn'), |
| 9 |
(0x80001, _utf32 0x80001, 'In Plane 8', 'Cn'), |
| 10 |
(0x90001, _utf32 0x90001, 'In Plane 9', 'Cn'), |
| 11 |
(0xA0001, _utf32 0xA0001, 'In Plane 10','Cn'), |
| 12 |
(0xB0001, _utf32 0xB0001, 'In Plane 11','Cn'), |
| 13 |
(0xC0001, _utf32 0xC0001, 'In Plane 12','Cn'), |
| 14 |
(0xD0001, _utf32 0xD0001, 'In Plane 13','Cn'), |
| 15 |
(0xF0001, _utf32 0xF0001, 'In Plane 15','Cn'), |
| 16 |
(0x100001 ,_utf32 0x100001,'In Plane 16','Cn'); |
| 17 |
|
| 18 |
|
| 19 |
select hex(convert(uc using utf32)), |
| 20 |
hex(weight_string(convert(uc using utf8mb4) collate utf8mb4_0900_bin)), |
| 21 |
name from unicode |
| 22 |
order by uc collate utf8mb4_0900_bin, cp; |
| 23 |
|
| 24 |
drop table if exists unicode; |