关于四字节字符入库时错误的解决方案(Incorrect string value: 'xF0x9Fx99x8F' for column 'Reply_Content' at row 1)

1. 将表字段字符集设置成utf8mb4
2. 执行插入前执行:SET NAMES utf8mb4;
如:
SET NAMES utf8mb4;
INSERT test(Content) VALUES('~');

PHP例子:
$paramValues=array('Content'=>'~');
$dbCommand->query('SET NAMES utf8mb4');
$lastInsertID=$dbCommand->insertOne('test',$paramValues);

原文地址:https://www.cnblogs.com/krisy/p/3524170.html