看目前此Mysql系統 所用的字元編碼
mysql> show variables like 'char%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+
時常遇到有中文編碼問題只要下此指令通常都可以解決(有時候也不一定,通常字元編碼相互轉換時出現錯誤)
mysql> set names [utf8|big5|其他編碼]
此命令其實是修改以下與Client端相關的變數
character_set_client character_set_connection character_set_results
與Mysql伺服器相關變數
character_set_database character_set_server character_set_system
(資料來源:可可西-http://www.cnblogs.com/kekec/archive/2013/05/08/3048225.html)