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都变成???
,证明存储成功了