DROP TABLE IF EXISTS t1; CREATE TABLE t1(a VARCHAR(255) CHARACTER SET gbk, FULLTEXT(a)) ENGINE = InnoDB; SET NAMES utf8; DELETE FROM t1 LIMIT 1; SET NAMES latin1; DROP TABLE t1; CREATE TABLE t1(a VARCHAR(2) CHARACTER SET big5 COLLATE big5_chinese_ci, FULLTEXT(a)) ENGINE=<default_engine>; DROP TABLE t1;