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);