MySQL Chinese garbled--in MySQL in the Chinese into a question mark solution

Today, the server in the test, found in the database of Chinese all become question marks!

First think of this is the coding problem: So again set the database encoding to UTF8

However, the problem persists:

It was later discovered that the root of the problem should be:

Although the database encoding is UTF8, the tables and fields in the database are not UTF8

So to solve this problem, you have to set the database's Table and field encoding to UTF8:

Here's how it's set up:

Modify the database table encoding to UTF8:ALTER table ' table ' DEFAULT CHARACTER SET UTF8;

Modify the database field code to UTF8, of course you can change one field, but I'll tell you to modify the command at once: alter table ' tablename ' convert to character set UTF8;

MySQL Chinese garbled--in MySQL in the Chinese into a question mark solution