blob: 98fd91a072c9fcd02de921fd3ca6ea891701083a (
plain)
1
2
3
4
5
6
7
8
9
|
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;
|
