Fix Java.sql.SQLException:Incorrect String value: ' \xe6\x88\x91\xe7\x9a\x84 ' for column ' GroupName '

Today, using MySQL to write data to MySQL in a Java program, the following error occurred:

caused By:java.sql.SQLException:Incorrect string value: ' \xd3\xcd\xbb\xad ' for column ' type ' at row 1

Solution:

You must set the data encoding when creating each table:

Drop Table if existsWe_artwork_desc;CREATE TABLEWe_artwork_desc (IDVARCHAR( $), filenameVARCHAR( $), typeVARCHAR( $), DESCRPVARCHAR( -),        PRIMARY KEY(ID)) charset GBK;

Fix Java.sql.SQLException:Incorrect String value: ' \xe6\x88\x91\xe7\x9a\x84 ' for column ' GroupName '