set names utf8; drop table if exists t1; CREATE TABLE `t1` ( `id` int(11) NOT NULL, `word` varchar(50) collate utf8_unicode_ci NOT NULL, `intval` int not null, UNIQUE KEY `word_id_key` (`word`,`id`), KEY `id_key` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; INSERT INTO t1 (id, word, intval) VALUES (1,'DDD',0); DELETE FROM t1 ; INSERT INTO t1 (id, word, intval) VALUES (1,'DDD',0) ;