一般如果把程序、配置文件和數(shù)據(jù)庫(kù)字符格式都設(shè)置成utf8字符的話是不會(huì)出現(xiàn)亂碼的。
可以通過(guò)命令
SHOW VARIABLES LIKE '%character_set_%'
察看Mysql的編碼設(shè)置
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, E:softProgrammysqlmysql-5.0.22-win32sharecharsets