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/

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

[img]http://dl2.iteye.com/upload/attachment/0092/4185/e7956698-c865-33cb-80a2-4f745b9a8b58.png[/img]

show variables like 'character_set_%';

[img]http://dl2.iteye.com/upload/attachment/0092/4191/85c6db4a-ac64-3eec-bcfc-76e6068db1a8.png[/img]