在富文本中添加emoji表情,再存入数据数据时,会报sql异常
在网上找了一些方法,按照步骤修改了数据库、表和对应字段的编码格式为utf8mb4,但是还是报错。
org.springframework.jdbc.UncategorizedSQLException:
### Error updating database. Cause: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x8C\xB9\xF0\x9F...' for column 'content' at row 1
### The error may involve com.xxx.mapper.xxxMapper.insertSelective-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO xxxTable(id,title,content,create_by,update_by) VALUES( ?,?,?,?,?)
### Cause: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x8C\xB9\xF0\x9F...' for column 'content' at row 1
; uncategorized SQLException; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF0\x9F\x8C\xB9\xF0\x9F...' for column 'content' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF0\x9F\x8C\xB9\xF0\x9F...' for column 'content' at ro