[MySQL] MySQL使用utf8mb4字符集

来源：互联网发布：矩阵的秩怎么算编辑：程序博客网时间：2024/05/29 07:59

MySQL使用utf8mb4字符集

更改配置文件my.ini

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

重启mysql服务
windows下5.6版本启动/停止服务器命令：

net start mysql56net stop mysql56

查看修改结果

SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';+--------------------------+--------------------+| Variable_name            | Value              |+--------------------------+--------------------+| character_set_client     | utf8mb4            || character_set_connection | utf8mb4            || character_set_database   | utf8mb4            || character_set_filesystem | binary             || character_set_results    | utf8mb4            || character_set_server     | utf8mb4            || character_set_system     | utf8               || collation_connection     | utf8mb4_unicode_ci || collation_database       | utf8mb4_unicode_ci || collation_server         | utf8mb4_unicode_ci |+--------------------------+--------------------+

JDBC 连接URL

jdbc:mysql://localhost:3306/database

0 0