mysql set character_set_database=utf8设置无效,为什么?

Question

show variables like '%char%';
显示mysql编码如下:
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8

设置set character_set_database=utf8之后再打开查询character_set_database 还是显示latin1, 为什么?

Answer 1

应该是你安装mysql的时候设置的是latin1，试试这样做1、在在MySql的安装目录下名字叫my.ini   --在 [mysqld] 标签下加上以下内容：default-character-set = utf8character_set_server = utf8注意：如果此标签下已经存在“default-character-set=GBK”类似的内容，只需修改即可。--在 [mysql]  标签下加上一行default-character-set = utf8  --在 [mysql.server]标签下加上一行default-character-set = utf8  --在 [mysqld_safe]标签下加上一行default-character-set = utf8  --在 [client]标签下加上一行default-character-set = utf82、  重新启动MySql服务