show variables like 'character%'set 變量名 = utf-8
show full columns from enpense \G;
字段變量
alter table enpense convert to character set gbk;
修改表默認字符集：
ALTER TABLE enpense DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
SHOW FULL COLUMNS FROM enpense
ALTER TABLE enpense CONVERT TO CHARACTER SET gbk;
ALTER TABLE 'enpense' MODIFY COLUMN 'end_data' DATE CHARACTER SET gbk;
SELECT * FROM enpense;
ALTER TABLE enpense DEFAULT CHARACTER SET utf8 COLLATE utf8;
ALTER TABLE enpense DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
http://www.jb51.net/article/68856.htm