mysql 处理utf8mb4的问题
jdbc端的characterEncoding=utf8 无法改为utf8mb4
测试:
create table utf8mb4_test (name1 varCHAR(20) CHARACTER SET utf8mb4, name2 varCHAR(20) CHARACTER SET utf8);
通过语句 stmt.execute("set names utf8mb4");
后再执行 stmt.execute("INSERT INTO risk_cds_education_audit_log(os_name,os_company_name)VALUES('1234test','王家园45\uD83D\uDC4C**')");
即可。此种情况,除了将目标表中的字段改为外,无需改动数据库任何地方。
SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%';
grant All on poc.* to dbtest@'%' identified by 'Btmysql_1234';
如果mysqld group 设置了character_set_server=utf8mb4,则client端无需做任何改动即可使用。
For Connector/J 5.1.46 and earlier: In order to use the utf8mb4 character set for the connection, the server MUST be configured with character_set_server=utf8mb4; if that is not the case, when UTF-8 is used for characterEncoding in the connection string, it will map to the MySQL character set name utf8, which is an alias for utf8mb3.
For Connector/J 5.1.47 and later: When UTF-8 is used for characterEncoding in the connection string, it maps to the MySQL character set name utf8mb4.
驱动更换为5.1.47即可
最新文章
- CSS SANS – 神奇!使用 CSS3 创建的字体
- MongoDB 数据库管理(不定时更新)
- day17算法
- I2C控制器的Verilog建模之二
- jsoup Cookbook(中文版)--爬虫(java)
- [King.yue]EXT.Grid行双击事件
- 某些手机一直连不上adb的解决办法
- war文件
- CSS学习笔记总结和技巧
- ASP.NET Zero--7.控制器加权限
- OSG+Python
- 卷积神经网络CNN的意义
- java.lang.Enum
- (转)开源项目miaosha(上)
- Delphi根据方法名调用方法
- python string tuple list dict 相互转换的方法
- python 读不同编码的文本,传递一个可选的encoding 参数给open() 函数
- Codeforces 832C - Strange Radiation
- C# WPF Image控件下对于Base64的转化显示
- 掀开图片显示介绍的css效果