polardbxengine/mysql-test/suite/xengine_collations/t/hungarian.test

62 lines
4.2 KiB
Plaintext

--source suite/xengine_collations/include/unicode.inc
insert into unicode values (0x100001,'cs','Hungarian cs','Ll');
insert into unicode values (0x100002,'Cs','Hungarian Cs','Lt');
insert into unicode values (0x100003,'CS','Hungarian CS','Lu');
insert into unicode values (0x100004,'DZ','Hungarian DZ','Lu');
insert into unicode values (0x100005,'Dz','Hungarian Dz','Lt');
insert into unicode values (0x100006,'dz','Hungarian dz','Ll');
insert into unicode values (0x100007,'DZS','Hungarian DZS','Lu');
insert into unicode values (0x100008,'Dzs','Hungarian Dzs','Lt');
insert into unicode values (0x100009,'dzs','Hungarian dzs','Ll');
insert into unicode values (0x10000A,'GY','Hungarian GY','Lu');
insert into unicode values (0x10000B,'Gy','Hungarian Gy','Lt');
insert into unicode values (0x10000C,'gy','Hungarian gy','Ll');
insert into unicode values (0x10000D,'NY','Hungarian NY','Lu');
insert into unicode values (0x10000E,'Ny','Hungarian Ny','Lt');
insert into unicode values (0x10000F,'ny','Hungarian ny','Ll');
insert into unicode values (0x100010,'LY','Hungarian LY','Lu');
insert into unicode values (0x100011,'Ly','Hungarian Ly','Lt');
insert into unicode values (0x100012,'ly','Hungarian ly','Ll');
insert into unicode values (0x100013,'SZ','Hungarian SZ','Lu');
insert into unicode values (0x100014,'Sz','Hungarian Sz','Lt');
insert into unicode values (0x100015,'sz','Hungarian sz','Ll');
insert into unicode values (0x100016,'TY','Hungarian TY','Lu');
insert into unicode values (0x100017,'Ty','Hungarian Ty','Lt');
insert into unicode values (0x100018,'ty','Hungarian ty','Ll');
insert into unicode values (0x100019,'ZS','Hungarian ZS','Lu');
insert into unicode values (0x10001A,'Zs','Hungarian Zs','Lt');
insert into unicode values (0x10001B,'zs','Hungarian zs','Ll');
insert into unicode values (0x10001C,'CCS','Hungarian CCS','Lu');
insert into unicode values (0x10001D,'Ccs','Hungarian Ccs','Lt');
insert into unicode values (0x10001E,'ccs','Hungarian ccs','Ll');
insert into unicode values (0x10001F,'DDZ','Hungarian DDZ','Lu');
insert into unicode values (0x100020,'Ddz','Hungarian Ddz','Lt');
insert into unicode values (0x100021,'ddz','Hungarian ddz','Ll');
insert into unicode values (0x100022,'DDZS','Hungarian DDZS','Lu');
insert into unicode values (0x100023,'Ddzs','Hungarian Ddzs','Lt');
insert into unicode values (0x100024,'ddzs','Hungarian ddzs','Ll');
insert into unicode values (0x100025,'DDZS','Hungarian DDZS','Lu');
insert into unicode values (0x100026,'Ddzs','Hungarian Ddzs','Lt');
insert into unicode values (0x100027,'ddzs','Hungarian ddzs','Ll');
insert into unicode values (0x100028,'GGY','Hungarian GGY','Lu');
insert into unicode values (0x100029,'Ggy','Hungarian Ggy','Lt');
insert into unicode values (0x10002A,'ggy','Hungarian ggy','Ll');
insert into unicode values (0x10002B,'LLY','Hungarian LLY','Lu');
insert into unicode values (0x10002C,'Lly','Hungarian Lly','Lt');
insert into unicode values (0x10002D,'lly','Hungarian lly','Ll');
insert into unicode values (0x10002E,'NNY','Hungarian NNY','Lu');
insert into unicode values (0x10002F,'Nny','Hungarian Nny','Lt');
insert into unicode values (0x100030,'nny','Hungarian nny','Ll');
insert into unicode values (0x100031,'SSZ','Hungarian SSZ','Lu');
insert into unicode values (0x100032,'Ssz','Hungarian Ssz','Lt');
insert into unicode values (0x100033,'ssz','Hungarian ssz','Ll');
insert into unicode values (0x100034,'TTY','Hungarian TTY','Lu');
insert into unicode values (0x100035,'Tty','Hungarian Tty','Lt');
insert into unicode values (0x100036,'tty','Hungarian tty','Ll');
insert into unicode values (0x100037,'ZZS','Hungarian ZZS','Lu');
insert into unicode values (0x100038,'Zzs','Hungarian Zzs','Lt');
insert into unicode values (0x100039,'zzs','Hungarian zzs','Ll');
select hex(convert(uc using utf32)), hex(weight_string(convert(uc using utf8mb4) collate utf8mb4_hu_0900_ai_ci)), name from unicode where category in ('Lu','Ll','Lt','Lm') order by uc collate utf8mb4_hu_0900_ai_ci, cp;
select hex(convert(uc using utf32)), hex(weight_string(convert(uc using utf8mb4) collate utf8mb4_hu_0900_as_cs)), name from unicode where category in ('Lu','Ll','Lt','Lm') order by uc collate utf8mb4_hu_0900_as_cs, cp;
drop table if exists unicode;