解决MySQL 数据库字符集编号错误 Incorrect string value: ‘\xF0\x9F\x98\xAD",…’ for column ‘commentContent’ at row 1
修改mysql的配置文件,windows下的为my.ini(linux下的为my.cnf),修改的内容都一样

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

华为云数据库修改方式:

Incorrect string value: ‘\xF0\x9F\x98\xAD“,...‘ for column ‘commentContent‘ at row 1_数据库