mariadb设置utf8mb4

1 . mysql真正的utf8是utf8mb4才是有效的utf8

  a). mariaDB的设置方法      

1
2
3
4
5
6
7
8
9
10
11
12
#vim /etc/my.conf
 
[mysqld]
character_set_server=utf8mb4 
collation-server=utf8mb4_unicode_ci 
init_connect='SET NAMES utf8mb4' 
skip-character-set-client-handshake=true 
 
#/etc/init.d/mariadb reload
 
#验证方法,登陆mysql
$SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';

  

      b) mysql的设置方法  

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
#vim /etc/my.conf
 
[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'
 
#/etc/init.d/mariadb reload
 
#验证方法,登陆mysql
$SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';

  

 

posted @   三百里江山  阅读(3527)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示