Phpmyadmin Chinese display numbers + lowercase letters, and common garbled characters

Phpmyadmin Chinese display number + lowercase letters, and common garbled http://zhidao.baidu.com/link? Url = qn78e6uO1HxBwuE8If8JZhRjbQBfr2vWefT-ye4rEJfy4rTs2BoXbqMbyGXnqPpDMUdrdkke0-UM-1ggg0xPM _
Only one post in Baidu is the same as mine, but the subject has not provided a solution.
Hope you can give me some guidance. thank you.

Reply to discussion (solution)

Paste your data

The title should be Chinese, but it is displayed as garbled characters with numbers and lower-case letters. if you click edit and view the database from other terminals, nothing is garbled ,.

It's a hexadecimal internal code. I have never seen this happen.
Look at your table structure

It's related to phpmyadmin. since the terminal query is normal, leave him alone.

It's a hexadecimal internal code. I have never seen this happen.
Look at your table structure

This is the database structure and table structure.

That's right. your connection proofreader (collate) is utf8_bin.
So that's it.

That's right. your connection proofreader (collate) is utf8_bin.
So that's it.

This data table is exported from a friend and then imported to my database. it is normal to show it in a friend. I tried to create a new database and change the connection verification to utf8_bin.

The answer to xuzuning has solved my problem. thank you!