Analysis of garbled data inserted into MySQL database

(1) The first case when creating a new database

(2) The second case is that the configuration encoding in the IDE environment is set to UTF-8

(3) The third case is when the database is connected, no encoding is set. This is the most conventional. This looks easy to solve, but you need to be aware of the MySQL version of the issue, such as the 5.6 version of the link URL setting code suffix may be:

?useoldaliasmetadatabehavior=true&useunicode=true&charsetencode=utf8&usessl=false; and previous versions are:

? useunicode=true&characterencoding=utf-8.
If this negligence is mistaken, the subconscious must feel that they have set the encoding format, resulting in the problem can not be found!
The above problem is not resolved, there are problems, we recommend reloading MySQL

Analysis of garbled data inserted into MySQL database