一般如果把程序、配置文件和數據庫字符格式都設置成utf8字符的話是不會出現亂碼的。
可以通過命令
SHOW VARIABLES LIKE '%character_set_%'
察看Mysql的編碼設置
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