MySQL中文乱码问题

来源：互联网发布：服务器端口开放工具编辑：程序博客网时间：2024/06/14 03:19

mysql5.7中文乱码问题的解决，将编码统一改成utf8的方法

修改配置文件my.ini

将其改为：（路径根据自己mysql的安装路径进行适当调整，与字符编码无关，不必改动）

[mysqld] 

basedir=C:\MYSQL57

datadir=C:\MYSQL57\data

character_set_server=utf8

collation-server=utf8_general_ci

[client] 

default-character-set=utf8

重新启动mysql服务

执行SHOW VARIABLES LIKE 'character%';即可看到：

mysql> SHOW VARIABLES LIKE 'character%';

+--------------------------+----------------------------+

| 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       | C:\MYSQL57\share\charsets\ |

+--------------------------+----------------------------+

8 rows in set, 1 warning (0.00 sec)

阅读全文

0 0