更改character_set_connection utf8mb4 mysql

Question

我想改变character_set_connection utf8mb4。它给我看utf8。我跟随了这篇https://mathiasbynens.be/notes/mysql-utf8mb4文章，并更改了

[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

Also fire this query. SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci but when I check current status in phpmyadmin using SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%'; result

character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
collation_connection utf8_general_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci

I have set alter tables and database

SET NAMES utf8mb4;  
ALTER DATABASE openfire CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;  
ALTER TABLE ofOffline CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; 

This is my connections string jdbc:mysql://localhost:3306/openfire?rewriteBatchedStatements=true&useUnicode=true
MySQL  5.6.33 I have check in windows with version 5.7.14 it's fine. Please give me any suggestions. Thanks in advance.  

Answer 1

你用的是什么客户？您将需要指定连接将与utf8mb4连接。

那桌子呢？如果您有现有的表，则需要一个ALTER ... CONVERT TO。