1USE test;
2create table p(v varchar(20), i int, primary key(v,i)) engine=innodb character set = utf8;
3create table c(k int primary key, v varchar(20), i int, foreign key(v,i) references p(v,i)) engine=innodb character set = utf8;
4insert into p values (_utf32 0x000004100000041100000412, 1);
5insert into c values (1, _utf32 0x000004100000041100000412, 1);
6SELECT * FROM test.p;
7v	i
8???	1
9SELECT * FROM test.c;
10k	v	i
111	???	1
12SELECT * FROM test.p;
13v	i
14???	1
15SELECT * FROM test.c;
16k	v	i
171	???	1
18DROP TABLE c;
19DROP TABLE p;
20