jdbc报Incorrect string value: '\xF0\x9F\xA4\x97' for column

最新推荐文章于 2023-07-20 12:28:38 发布

weixin_34319640

最新推荐文章于 2023-07-20 12:28:38 发布

阅读量567

点赞数

文章标签： python 数据库

原文链接：https://my.oschina.net/u/232595/blog/830959

版权

2019独角兽企业重金招聘Python工程师标准>>>

首先验证jdbc链接是否正确

jdbc:mysql://ip:port/dbname?"
        + "user=user&password=password&useUnicode=true&autoReconnect=true&characterEncoding=utf8

然后验证mysql配置

SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';

重点观察mysql配置是否是utf8mb4，如若不是检查/etc/my.cnf是否有以下配置

[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'

最后检查数据库、表字段定义

ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE table_name CHANGE column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

转载于:https://my.oschina.net/u/232595/blog/830959