解決方案：**mysql字符集設置為 utf8mb4**
### 設置 my.cnf
```
[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
```
### 數據庫、表、字段
```sql
ALTER DATABASE dbname CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `tbname` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `tbname` MODIFY COLUMN `colname` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
```
### PHP 數據庫連接設置
設置 mysql 數據庫配置文件的字符集以及校對集
