安装mysql时,如果按照默认的设置点击下一步,会导致数据库的默认编码是latin1,项目连接数据库进行保存时,会导致出现乱码
这样就需要把编码方式改为UTF-8
mysql设置编码命令
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; |
mysql> SHOW VARIABLES LIKE 'character%'; 可以看到全变为 utf8 。
但是,当重启数据库服务后还是会失效。
1,修改
my.ini中下列地方 加default-character-set=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld] 某些操作系统中,在mysqld下可以不用加,有可能导致mysql服务无法启动,所以mysqld下也可不加
default-character-set=utf8
2,找到mysql路径下该文件
X:\%path%\MySQL\MySQL Server 5.0\bin\MySQLInstanceConfig.exe
重新启动设置,将默认编码设置为utf8
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;
mysql> SHOW VARIABLES LIKE 'character%';编码方式就更改过来了