mysql connectorJ字符集结果不支持utf8mb4 [英] mysql connectorJ character set results does not support utf8mb4

问题描述

我有一个具有与mysql的连接池的tomcat服务器.

在连接设置中，我可以在 *此页面中看到设置为utf8mb4的所有字符集编码用于character_set_results.

我的连接字符串为-

 jdbc:mysql://:3306/abc?character_set_server=utf8mb4&useOldAliasMetadataBehavior=true&character_set_connection=utf8mb4&characterEncoding=utf-8&character_set_results=utf8mb4

在mysql服务器中，我可以看到显示utf8mb4的character_set_results.

但是在jsp页面中，它还是无法显示.

mysql版本为5.6.16，连接器版本为5.1.22

致谢

解决方案

连接设置不需要characterEncoding和character_set_server，mysql connectorJ将自动检查.

确保character_set_database = utf8mb4，character_set_server = utf8mb4， 表字符集= utf8mb4，某些列使用varchar字符集= utf8mb4;

提示:character_set_server = utf8mb4需要配置my.ini 例子:

[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'

loose-default-character-set = utf8mb4
[client]
default-character-set = utf8mb4
loose-default-character-set = utf8mb4

https ://dev.mysql.com/doc/refman/5.6/zh-CN/charset-unicode-utf8mb4.html?spm = 5176.2020520165.110.53.AlPmXp

I m having a tomcat server having a connection pool to mysql.

In the connection settings i can see all the character set encodings set to utf8mb4 in *this page except for character_set_results.

My connection string being -

 jdbc:mysql://:3306/abc?character_set_server=utf8mb4&useOldAliasMetadataBehavior=true&character_set_connection=utf8mb4&characterEncoding=utf-8&character_set_results=utf8mb4

In the mysql server i can see character_set_results showing utf8mb4.

But in the jsp page it is not shown anyway.

The mysql version is 5.6.16 and connector version is 5.1.22

Regards

解决方案

connection settings need not characterEncoding and character_set_server, mysql connectorJ will auto check.

make sure character_set_database=utf8mb4,character_set_server=utf8mb4, Table character set=utf8mb4, some columns use varchar character set=utf8mb4;

tip: character_set_server=utf8mb4 need config my.ini Exemple:

[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'

loose-default-character-set = utf8mb4
[client]
default-character-set = utf8mb4
loose-default-character-set = utf8mb4

https://dev.mysql.com/doc/refman/5.6/en/charset-unicode-utf8mb4.html?spm=5176.2020520165.110.53.AlPmXp

这篇关于mysql connectorJ字符集结果不支持utf8mb4的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！