Mysql存储emoji表情

1、把数据表格式设置成utf8mb4

ALTER TABLE `tbl_live_comment00`
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci;

2、把要存储的字段设置成utf8mb4

ALTER TABLE `tbl_live_comment00`
MODIFY COLUMN `comment`  varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户评论' AFTER `uid`;

3、在代码中把连接数据库配置字符集改成utf8mb4

'db' => [
    'class' => 'yii\db\Connection',
    'dsn' => 'mysql:host=10.66.1.219;port=3306;dbname=yh_live',
    'username' => 'root',
    'password' => 'yoho@Uniformpass',
    'charset' => 'utf8mb4',
    'tablePrefix'=>'tbl_',
    'schemaCache' => 'pageCache',
    'queryCache' => 'pageCache',
    'attributes' => [
        \PDO::ATTR_TIMEOUT => 0.8,
    ],
],

4、用ios手机输入emoji表情，存储到数据库中看到emoji都变成???，证明存储成功了