Java read and write data garbled problem from MySQL

MySQL uses Latin (iso-8859-1) by default, while Java uses Unicode encoding by default. Therefore, when inserting data into the MySQL database in Java, or when reading data, it is necessary to first convert the encoding method.

1, first view the database encoding method:

Show variables like ' char% '

Make sure that the encoding used by the database is UTF8

2. View the encoding of the Java file:

3, if all is UTF8, the database of Chinese is normal, but read the content is garbled, want to completely solve this problem instead of each restart service to set the encoding method, it is recommended to reinstall MySQL database.

4, when the installation must be in this step

Select the third option and the guarantee is UTF8.

Java read and write data garbled problem from MySQL