CREATE DATABASE foo; USE foo; CREATE TABLE `t1` ( `word` varchar(50) collate utf8_unicode_ci NOT NULL default '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET @@session.character_set_client=33,@@session.collation_connection=192; CREATE TEMPORARY TABLE tmptbl504451f4258$1 (id INT NOT NULL, weight INT NULL, privil INT NULL) ENGINE=MEMORY ; INSERT INTO t1 (word) VALUES ('TEST’');