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