sequelize在云服务器上不支持中文如何解决

Question

在本地调试的时候，sequelize可以储存中文信息，并插入数据库
但是我把项目部署到云服务器上以后
中文会变成这样的：
%E6%9D%A5%E6%9D%A5%E6%9D%A5
报错信息：

SequelizeDatabaseError: Incorrect string value: '\xE6\xB5\x8B\xE8\xAF\x95' for column 'title' at row 1
      at Query.formatError (/backend/blog/node_modules/sequelize/lib/dialects/mysql/query.js:244:16)
      at Execute.handler [as onResult] (/backend/blog/node_modules/sequelize/lib/dialects/mysql/query.js:51:23)
      at Execute.execute (/backend/blog/node_modules/mysql2/lib/commands/command.js:30:14)
      at Connection.handlePacket (/backend/blog/node_modules/mysql2/lib/connection.js:408:32)
      at PacketParser.Connection.packetParser.p [as onPacket] (/backend/blog/node_modules/mysql2/lib/connection.js:70:12)
      at PacketParser.executeStart (/backend/blog/node_modules/mysql2/lib/packet_parser.js:75:16)
      at Socket.Connection.stream.on.data (/backend/blog/node_modules/mysql2/lib/connection.js:77:25)
      at emitOne (events.js:116:13)
      at Socket.emit (events.js:211:7)
      at addChunk (_stream_readable.js:263:12)
      at readableAddChunk (_stream_readable.js:250:11)
      at Socket.Readable.push (_stream_readable.js:208:10)
      at TCP.onread (net.js:597:20)

如何处理呢？

Answer 1

这是被 URL 编码了。

你插入的数据是从接口里的查询字符串取的？

插入之前先 decodeURIComponent 一下。