emoji一直报错 - Githubissues

tencentyun / wafer

Wafer - 快速构建具备弹性能力的微信小程序

https://github.com/tencentyun/wafer

Other

2.16k stars 333 forks source link

emoji一直报错 #47

Closed xrlu0929 closed 5 years ago

xrlu0929 commented 5 years ago

用户微信昵称如果含有emoji 则没有办法post到MySQL上（已经设置过各种utf8mb4）。。。每次报错都说 ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value: '\xF0\x9F\x90\x9F' for column 'nickName' at row 1 求助

xrlu0929 commented 5 years ago

没事了。。解决方式：在utils/db.js 的：pool connection里增加charset:config.char `const mysql = require('mysql') const config = require('../config').mysql

var pool = null

/**

鍒濆鍖栬繛鎺ユ睜 */ function initMysqlPool() { pool = mysql.createPool({ connectionLimit: 50, database: config.db, host: config.host, port: config.port, user: config.user, password: config.pass, charset: config.char }); }` 似乎其他不需要更改