Debian Codegraph @

mysql-test/suite/collations/t/japanese.test

raw
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;