MySQL UTF8 way connection view table data garbled problem

Cause

Today in the company for the first time link a new MySQL database, I see in spring configured in JDBC Datasource.url configuration Characterencoding=utf8. Then use navicat Open Select UTF8 link database, results see table data Chinese all garbled ...

Solutions

You can use show variables like ' Character_set_database' and show create table Yourtablename to see the Database and table encodings: Then I found out that we were using UTF8MB4 ... Then select the corresponding encoding on the line. or choose automatic encoding (I used to manually select the specified encoding).

Please refer to the difference between UTF8 and UTF8MB4 50041603

According to this article, the JDBC URL can be written UTF8. So there is no problem in Java, but a link tool on GG

MySQL UTF8 way connection view table data garbled problem