LouisLan的学习简记 👋🏼

记录一次数据库插入表情时的报错解决方式 错误复现：在向数据库插入类似表情 😄 😱 这样的数据时，发生了错误，示例如下： [ERROR 06-10 17:34:08 sor.CommentProcessor 363] Can not add comment on article org.b3log.latke.service.ServiceException: org.b3log.latke.repository.RepositoryException: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x91\x8E \xF0...' for column 'commentContent' at row 1 at org.b3log.solo.service.CommentMgmtService.addArticleComment(CommentMgmtService.java:340) at org.b3log.solo.service.CommentMgmtService_$$_jvst268_4e._d0add....

参考自：https://www.cnblogs.com/zero-vic/p/13296857.html 下载mysql yum包： wget http://repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm 安装mysql rpm -Uvh mysql57-community-release-el7-10.noarch.rpm 安装mysql server端 yum install -y mysql-community-server 结果： [root@VM-8-15-centos ~]# yum install -y mysql-community-server Loaded plugins: fastestmirror, langpacks, product-id, search-disabled-repos, subscription-manager This system is not registered with an entitlement server. You can use sub....