大部分人在执行完1、2、3的操作后,<br/>
还是没有效果,之前我也是这样。
<br/>
<br/>
So下面4、5、6是必须要做的,这样就好了。
<br/>
1、
my.cnf修改
[mysqld]下添加
default-character-set=utf8
添加
[client]
default-character-set=utf8
2、创建数据库时在建库语句后加上character set utf8;
在创建表语句后加上character set utf8;
3、修改当前数据库设置;
show variables like 'collation_%';
如果执行以上语句不是这样的结果,则使用set collation_connection='utf8_general_ci
'这样的命令修改一下三个变量;
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
show variables like 'character_set_%';
如果执行上面命令结果不是如下,则使用set
character_set_client='utf8'这样的命令修改设置如下;
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
重启数据库
4、修改当前已存在数据库的编码
alter database dbname character set uft8
5、修改当前已存在表的编码
alter table tb_xxxx character set utf8;
6、把所有表的字段都转换为utf8
alter table tb_user CONVERT TO CHARACTER SET utf8
转载请说明出处