背景:由于要解决java.sql.SQLException: Incorrect string value: '\xF0\x9F\x92\x94' for column 'name' at row 1异常,所以要修改mysql字符集,改为utf8mb4。
修改字符集参考文章如下(参考修改后都没有效果):
https://www.jb51.net/article/144079.htm
https://blog.csdn.net/u014034329/article/details/80969246
mysql信息:
version:5.7.22免安装版
路径:D:\Work_Program_Files\mysql
my.ini文件信息:
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
init_connect='set names utf8mb4'
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
mysql已经配置成windows服务,并且启动成功。但是通过navicatformysql登录mysql,通过show VARIABLES like 'char%'; 命令查询出结果为如下:
变量character_set_client、character_set_connection、character_set_results、character_set_system没有改为utf8mb4
问题:如何修改mysql字符集,保证character_set_client、character_set_connection、character_set_results、character_set_system变量的字符集为utf8mb4