### SQL: INSERT INTO hq_send_log ( id, send_obj, send_time, method_url, ip_address, haier_return_obj, detect_data_ids, send_count, send_status, create_time ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
### Cause: java.sql.SQLException: Incorrect string value: '\xF0\x9F\xA6\x8C2\xE5...' for column 'send_obj' at row 1
原因:
insert时,send_obj字段存的数据带表情🦌,该字段的字符集和排序规则设置是utf8
解决
字符集和排序规则改成:utf8mb4和utf8mb4_general_ci