Nodejs的mysql中插入 表情符号 报错 Error: ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value: ‘\xF0\...

1.首先需要设置数据库，表，字段的字符集和排序规则都为utf8mb4

2.在引入mysql或者封装mysql处定义类型 charset: "utf8mb4",

const db = mysql.createPool({

  host: "127.0.0.1",

  user: "root",

  password: "123456",

  database: "Juejing",

  port: 3306,

  charset: "utf8mb4",

});

3.此时重启Nodejs服务即可