Home > Database > Mysql Tutorial > 解析mysql修改为utf8后仍然有乱码的问题

解析mysql修改为utf8后仍然有乱码的问题

WBOY
Release: 2016-06-07 16:16:52
Original
1112 people have browsed it

解决方法: 1、找到mysql安装目录c:Program FilesMySQLMySQL Server 5.5下的my.ini 2、修改一下三处,注意通常只能搜索到[mysql]和[mysqld]两处,[client]处需要增加: [client] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld] de

解决方法:
1、找到mysql安装目录c:Program FilesMySQLMySQL Server 5.5下的my.ini
2、修改一下三处,注意通常只能搜索到[mysql]和[mysqld]两处,,[client]处需要增加:
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8
3、保存my.ini,在控制面板里找到服务,重启mysql服务。

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template