Execute the following statement at once
Show VARIABLES like ' character_% '; Set Character_set_server=utf8; Show full columns from t_org; Show table status from HrpA like '%t_% '; Show CharSet;
Found the table basically no problem, can also echo UTF8, the result of inserting data is the same?? Such a garbled.
Last entry
My.ini
[MySQL] no-auto-rehash default-character-set = UTF8
[Mysqld] port=3306 Default-character-set=utf8 default-storage-engine=innodb
And then into the corresponding database configuration file
Db.opt
File contents
Default-character-set=utf8 Default-collation=utf8_general_ci
Originally did not add the default character encoding, that is, with the set named restart is also garbled. The problem is over.
Transferred from: http://blog.csdn.net/apollo_ts/article/details/5389801
The problem of MySQL garbled in phpadmin