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