MySQL utf8mb4设置方法 MySQL

Cool.Cat 2017-09-02 2132

[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 
init_connect='SET NAMES utf8mb4'

重启 MySQL Server、检查字符集

mysql> 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 | 
+--------------------------+--------------------+ 
rows in set (0.00 sec)
最新回复 (0)
返回
发新帖
X