Exception in thread & quot; main & quot; java. SQL... Solution

Exception in thread "main" java. SQL .. A java + mysql program has been written on the local machine, but when it is transplanted to other machines, an error is always reported when the database is inserted, as shown in [java] Exception in thread "main" java. SQL. SQLException: Incorrect string value: '\ xF0 \ xA2 \ x9C \ xB6 \ xE2 \ x80... 'for column 'value' at row 1 at com. mysql. jdbc. mysqlIO. checkErrorPacket (MysqlIO. java: 2975) at com. mysql. jdbc. mysqlIO. sendCommand (MysqlIO. java: 1600) .... the reason is as follows: In Eclipse, the encoding is GBK. When configuring Mysql on the local machine, the encoding is GBK. However, when encoding is configured for mysql on the target computer, latin1 or utf8 is selected, leading to the above error. Solution: Enter MySQL Server Instance Configuration and change mysql character encoding to GBK! This error occurs because the character encoding in mysql is different from that in the program.