select "armscii8 (1b)"; alter table t1 convert to character set armscii8; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "ascii (1b)"; alter table t1 convert to character set ascii; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "binary (1b)"; alter table t1 convert to character set binary; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "cp1250 (1b)"; alter table t1 convert to character set cp1250; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "cp1251 (1b)"; alter table t1 convert to character set cp1251; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "cp1256 (1b)"; alter table t1 convert to character set cp1256; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "cp1257 (1b)"; alter table t1 convert to character set cp1257; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "cp850 (1b)"; alter table t1 convert to character set cp850; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "cp852 (1b)"; alter table t1 convert to character set cp852; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "cp866 (1b)"; alter table t1 convert to character set cp866; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "dec8 (1b)"; alter table t1 convert to character set dec8; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "geostd8 (1b)"; alter table t1 convert to character set geostd8; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "greek (1b)"; alter table t1 convert to character set greek; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "hebrew (1b)"; alter table t1 convert to character set hebrew; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "hp8 (1b)"; alter table t1 convert to character set hp8; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "keybcs2 (1b)"; alter table t1 convert to character set keybcs2; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "koi8r (1b)"; alter table t1 convert to character set koi8r; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "koi8u (1b)"; alter table t1 convert to character set koi8u; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "latin1 (1b)"; alter table t1 convert to character set latin1; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "latin2 (1b)"; alter table t1 convert to character set latin2; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "latin5 (1b)"; alter table t1 convert to character set latin5; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "latin7 (1b)"; alter table t1 convert to character set latin7; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "macce (1b)"; alter table t1 convert to character set macce; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "macroman (1b)"; alter table t1 convert to character set macroman; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "swe7 (1b)"; alter table t1 convert to character set swe7; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "tis620 (1b)"; alter table t1 convert to character set tis620; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #1b select "big5 (2b)"; alter table t1 convert to character set big5; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #2b select "cp932 (2b)"; alter table t1 convert to character set cp932; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #2b select "euckr (2b)"; alter table t1 convert to character set euckr; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #2b select "gb2312 (2b)"; alter table t1 convert to character set gb2312; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #2b select "gbk (2b)"; alter table t1 convert to character set gbk; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #2b select "sjis (2b)"; alter table t1 convert to character set sjis; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #2b select "ucs2 (2b)"; alter table t1 convert to character set ucs2; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #2b select "eucjpms (3b)"; alter table t1 convert to character set eucjpms; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #3b select "ujis (3b)"; alter table t1 convert to character set ujis; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #3b select "utf8 (3b)"; alter table t1 convert to character set utf8; ALTER TABLE t1 CHANGE c d varchar(10); ALTER TABLE t1 CHANGE d c varchar(10); #3b