linux mysql 字符集相关问题解决备忘
linux mysql 字符集相关问题解决备忘

mysql -uroot -p123456 -e "show variables"|grep -i chara

其中 -i 是 不区分大小写

之前错误的结果

character_set_client    latin1
character_set_connection        latin1
character_set_database  latin1
character_set_filesystem        binary
character_set_results   latin1
character_set_server    latin1
character_set_system    utf8
character_sets_dir      /usr/share/mysql/charsets/

修改以后正确的结果

character_set_client    latin1
character_set_connection        latin1
character_set_database  utf8
character_set_filesystem        binary
character_set_results   latin1
character_set_server    utf8
character_set_system    utf8
character_sets_dir      /usr/share/mysql/charsets/