mysql修改字符级成utf8

来源：互联网发布：复利盘源码编辑：程序博客网时间：2024/06/07 00:51

1.          MySQL/MySQL Server 5.0/my.ini中修改两个地方字符级：
       (将值改为utf8)，改后结果如下：
      default-character-set=utf8
      default-character-set=utf8

2.          启动-->程序-->mysql-->mysql server-->MySQL Command Line Client

输入密码回车，分别输入命令：
show variables like 'collation_%';
show variables like 'character_set_%';

查看当前字符级，结果应该分别应是：

+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database   | utf8_general_ci |
| collation_server     | utf8_general_ci |
+----------------------+-----------------+
和
+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+

3.          如果不是上边结果，通过执行如下命令修改：
set character_set_client=utf8;
set character_set_connection=utf8;
set character_set_database=utf8;
set character_set_results=utf8;
set character_set_server=utf8;
set character_set_system=utf8;
set collation_connection=utf8;
set collation_database=utf8;
set collation_server=utf8;

4.          重启数据库服务，再通过上边两个查看命令查看字符级，（可能character_set_filesystem 不显示，可以忽略）