mysql中插入emoji失败
Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x94\xA5' for column
1.需要修改数据库中对应列的编码集
由utf-8编码集修改为utf8mb4
2.需要配置node项目中mysql的属性:如下
var mysql = require('mysql');module.exports = mysql.createPool( {host: '',user: '',password: '12345',database:'', port: 3306,charset:'UTF8MB4_GENERAL_CI'}
);
必须设置数据里的字符集为 UTF8MB4_GENERAL_CI