mysql 无法存储表情字符 java.sql.SQLException: Incorrect string value: '\xF0\x9F\x90\xBE",...' for column 'XX...

1、变更字段类型

ALTER TABLE api_log MODIFY COLUMN remark longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

2、配置数据库链接

url="jdbc:mysql://XXXXXXX/dbName?useSSL=false&useUnicode=true&characterEncoding=utf8&autoReconnect=true"

转载于:https://www.cnblogs.com/101key/p/11338324.html