### Error:Incorrect string value: ‘\xF0\x9F\x91\x8

完整报错：

### Error updating database.  Cause: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x91\x87</...' for column 'content' at row 1
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: INSERT into goods_article (recommend_item_id,content,title,article_desc)         values (?,?,?,?)
### Cause: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x91\x87</...' for column 'content' at row 1
; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF0\x9F\x91\x87</...' for column 'content' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF0\x9F\x91\x87</...' for column 'content' at row 1
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:90)

大概意思 就是sql插入这个\xF0\x9F\x91\x8字符串插入不进去

JDBC不支持‘可爱的’emoj表情图

所以，在我们配置文件里就加入一下代码：

导入Maven

  <!-- https://mvnrepository.com/artifact/org.apache.commons/commons-dbcp2 -->
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-dbcp2</artifactId>
            <version>2.1.1</version>
            <scope>runtime</scope>
        </dependency>

#数据库支持emoj表情包
spring.datasource.type=org.apache.commons.dbcp2.BasicDataSource
spring.datasource.dbcp2.connection-init-sqls=SET NAMES utf8mb4