问题:
问题:Incorrect string value: ‘\xF0\x9F\x99\x82’ for column ‘xxx’ at row 1; nested exception is java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x99\x82’ for column ‘xxx’ at row 1
原因:表用的是utf8编码导致
解决:
修改表编码
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
结果如下: