MySQL插入emoji表情错误的3种解决方案，Incorrectstringvalue:'\xF0\x9F\x98\x84'

 Incorrect string value: &＃39;\xF0\x9F\x91\x84\u...&＃39; for column &＃39;message_content&＃39; at row 175

修改mysql的配置文件，windows下的为安装目录的my.ini

(linux下的为/etc/my.cnf)，修改的内容都一样

[client]
default-character-set = utf8mb4[mysql]
default-character-set = utf8mb4[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

windows 重启 mysql

net stop mysql

net start mysql