| 1 |
--source suite/collations/include/unicode.inc |
| 2 |
select hex(convert(uc using utf32)), |
| 3 |
hex(weight_string(convert(uc using utf8mb4) collate utf8mb4_ja_0900_as_cs)), |
| 4 |
name from unicode |
| 5 |
where category in ('Lu','Ll','Lt','Lm','Lo','So') |
| 6 |
order by uc collate utf8mb4_ja_0900_as_cs, cp; |
| 7 |
|
| 8 |
select hex(convert(uc using utf32)), |
| 9 |
hex(weight_string(convert(uc using utf8mb4) collate utf8mb4_ja_0900_as_cs_ks)), |
| 10 |
name from unicode |
| 11 |
where category in ('Lu','Ll','Lt','Lm','Lo','So') |
| 12 |
order by uc collate utf8mb4_ja_0900_as_cs_ks, cp; |
| 13 |
|
| 14 |
## Some specific Japanese features |
| 15 |
## Kana-sensitivity |
| 16 |
select 'の東京ノ' = 'ノ東京の' collate utf8mb4_0900_as_cs; |
| 17 |
select 'の東京ノ' = 'ノ東京の' collate utf8mb4_ja_0900_as_cs; |
| 18 |
select 'の東京ノ' = 'ノ東京の' collate utf8mb4_ja_0900_as_cs_ks; |
| 19 |
|
| 20 |
drop table if exists unicode; |