Cause: java.sql.SQLException: Incorrect string value: ‘xF0x9FxA6x8C2xE5...‘ for column ‘send

Cause: java.sql.SQLException: Incorrect string value: ‘xF0x9FxA6x8C2xE5...‘ for column ‘send

### 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: 'xF0x9FxA6x8C2xE5...' for column 'send_obj' at row 1

原因：

insert时，send_obj字段存的数据带表情歷，该字段的字符集和排序规则设置是utf8

解决

字符集和排序规则改成：utf8mb4和utf8mb4_general_ci