MySQL Chinese garbled solution method

Recently in the. NET project with the EF connection mysql, inserting Chinese data is always garbled, when the table was created, the encoding has been specified, but still garbled, tossing for a while to find in the connection string also add the specified code

Character Set=utf8 (Server=xxxxx;user id=xxxx;password=xxxxx; Character Set=utf8;d atabase=xxxxx)

To run the program again to insert data will not be garbled in the case of Chinese

In the Java project as well, if the connection string does not include the specified encoding, the insertion of Chinese data will appear garbled

jdbc.url=jdbc:mysql://xxxxxx/xxxxxxxx?useunicode=true&Characterencoding=utf8

It took some time to solve the problem, to summarize here

MySQL Chinese garbled solution method