[教程] Mysql支持utf8mb4編碼

Miker

修改數(shù)據(jù)庫和表的屬性為utf8mb4

1. ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
   
2. ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

復(fù)制代碼

linux下修改mysql的配置文件　

# vi /ect/my.cnf　

增加

1. [client]
   
2. default-character-set = utf8mb4
   
3. [mysql]
   
4. default-character-set = utf8mb4
   
5. [mysqld]
   
6. character-set-client-handshake = true
   
7. character-set-server = utf8mb4
   
8. collation-server = utf8mb4_unicode_ci
   
9. init_connect='SET NAMES utf8mb4'

復(fù)制代碼