1. The real UTF8 of MySQL is that UTF8MB4 is effective UTF8
a). How to set the MARIADB
#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# authentication method, login mysql$ SHOW VARIABLES WHERE variable_name like ' character\_set\_% ' OR variable_name like ' collation% ';
b) How MySQL is set up
#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# authentication method, login Mysql$show VARIABLES WHERE variable_name like ' character \_set\_% ' OR variable_name like ' collation% ';
MARIADB setting UTF8MB4