5
drop table if exists t1;
8
CREATE TABLE t1 SELECT _utf8'test' as c1, _utf8'тест' as c2;
11
ALTER TABLE t1 ADD c3 CHAR(4) CHARACTER SET utf8;
13
INSERT INTO t1 VALUES ('aaaabbbbccccdddd','aaaabbbbccccdddd','aaaabbbbccccdddd');
17
CREATE TABLE t1 (a CHAR(4) CHARACTER SET utf8, KEY key_a(a(3)));
20
ALTER TABLE t1 CHANGE a a CHAR(4);
23
ALTER TABLE t1 CHANGE a a CHAR(4) CHARACTER SET utf8;