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/

--------------------------------------------------

show variables like 'character_set_%';