MySQL database could not be inserted in Chinese what's going on?

Insert Chinese On Error:

Incorrect?string?value:? ' \xe7\x8f\xbd\xe7\x8f\xba '? For?column? ' Name '? at?row?1

With set names UTF8 or gb2312 can sometimes be inserted, but it is garbled, what is going on?

"Workaround"

This is because the encoding is not selected when the database is created, and the database is recreated with UTF8 encoding.

The encoding format is then set first when the query is executed.

SET names ' UTF8 '; INSERT into Test1 (name) VALUES (' Chinese ')

?

If you want to see the format supported by the current database, run the following command:

Show variables like ' char% ';

?

MySQL database could not be inserted in Chinese what's going on?