MySQL报错:Cause: java.sql.SQLException: Incorrect string value: '\xE6\x9D\xA8","...' for column 'obj_v

原因:你的mysql数据库中该字段不是utf8或utf8mb4编码,在该字段插入汉字或其他多字节编码时出现乱码

解决方案:
1、查询数据库版本:
select version();
MySQL报错:Cause: java.sql.SQLException: Incorrect string value: '\xE6\x9D\xA8","...' for column 'obj_v
2、查询数据库编码:
MySQL报错:Cause: java.sql.SQLException: Incorrect string value: '\xE6\x9D\xA8","...' for column 'obj_v
2、停掉数据库:
service mysqld stop
3、将数据库设置为utf8mb4编码:
MySQL报错:Cause: java.sql.SQLException: Incorrect string value: '\xE6\x9D\xA8","...' for column 'obj_v
增加配置文件:
collation_server = utf8mb4_general_ci
character_set_server = utf8mb4
[client]
default_character_set=utf8mb4

MySQL报错:Cause: java.sql.SQLException: Incorrect string value: '\xE6\x9D\xA8","...' for column 'obj_v
4、重启数据库
service mysqld restart

5、将你自己的数据库编码修改为utf8mb4

6、将自己表修改编码修改为utf8mb4

7、将对应字段编码修改为utf8mb4