mysql中字符编码问题
[*]查看当前编码方式，show variables like ‘%char%’;
[*]设置当前操作及显示编码方式 set names utf8;
[*]修改xxx表的默认字符集：alter table xxx default character set utf8;
[*]修改数据库xxx默认字符集：alter database xxx default character set utf8;
[*]修改表创建字段默认字符集：alter table xxx default character set utf8 collate utf8_general_ci;
[*]修改表所有字段默认字符集及当前字符集：alter table xxx convert to character set utf8 collate utf8_general_ci;
[*]修改某字段的字符集：alter table xxx change xxx chracter set utf8 not null …..;
页:
[1]