MySQL Utf8插入偏僻字符出错

Question

drop table if exists a;
CREATE TABLE a (
a varchar(255) NULL
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
;

select cast(0xD9D6 as char) into @x;
insert into a (a) values (@x);
select * from a;

Answer 1

字符集设成GBK试试