个人中心
gpt4 book ai didi

mysql - 无法输入 Unicode 数据、MySql、Express、M*EAN

转载 作者：行者123 更新时间：2023-11-29 20:48:19 25 4
gpt4 key购买 nike

我可以插入英文数据没有问题，但是当我插入高棉语时，出现此错误日志:

info: Session: { id: 1, username: john }
verbose: Executing (default): INSERT INTO `Articles` (`id`,`title`,`content`,`createdAt`,`updatedAt`,`UserId`) VALUES (DEFAULT,'ថេាាថេា','ថេថេាថេាឹ','2016-07-08 09:50:28','2016-07-08 09:50:28',1);
verbose: Executing (default): SELECT `id`, `sid`, `data`, `createdAt`, `updatedAt` FROM `Sessions` AS `Session` WHERE `Session`.`sid` = 'Qzad_nN3rMR2RrsZ-Oa3H4A5BfL2optm' LIMIT 1;
Unhandled rejection RangeError: Invalid status code: 0
    at ServerResponse.writeHead (_http_server.js:192:11)
    at ServerResponse.writeHead (/Users/Roller/Working/Web/mean-stack-relational/node_modules/on-headers/index.js:55:19)
    at ServerResponse.writeHead (/Users/Roller/Working/Web/mean-stack-relational/node_modules/on-headers/index.js:55:19)
    at ServerResponse.writeHead (/Users/Roller/Working/Web/mean-stack-relational/node_modules/on-headers/index.js:55:19)
    at ServerResponse._implicitHeader (_http_server.js:157:8)
    at ServerResponse.write (/Users/Roller/Working/Web/mean-stack-relational/node_modules/compression/index.js:83:14)
    at writetop (/Users/Roller/Working/Web/mean-stack-relational/node_modules/express-session/index.js:286:26)
    at ServerResponse.end (/Users/Roller/Working/Web/mean-stack-relational/node_modules/express-session/index.js:328:16)
    at ServerResponse.send (/Users/Roller/Working/Web/mean-stack-relational/node_modules/express/lib/response.js:205:10)
    at ServerResponse.json (/Users/Roller/Working/Web/mean-stack-relational/node_modules/express/lib/response.js:250:15)
    at ServerResponse.send (/Users/Roller/Working/Web/mean-stack-relational/node_modules/express/lib/response.js:152:21)
    at .<anonymous> (/Users/Roller/Working/Web/mean-stack-relational/app/controllers/articles.js:42:20)
    at tryCatcher (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/util.js:16:23)
    at Promise._settlePromiseFromHandler (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/promise.js:504:31)
    at Promise._settlePromise (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/promise.js:561:18)
    at Promise._settlePromise0 (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/promise.js:606:10)
Unhandled rejection RangeError: Invalid status code: 0
    at ServerResponse.writeHead (_http_server.js:192:11)
    at ServerResponse.writeHead (/Users/Roller/Working/Web/mean-stack-relational/node_modules/on-headers/index.js:55:19)
    at ServerResponse.writeHead (/Users/Roller/Working/Web/mean-stack-relational/node_modules/on-headers/index.js:55:19)
    at ServerResponse.writeHead (/Users/Roller/Working/Web/mean-stack-relational/node_modules/on-headers/index.js:55:19)
    at ServerResponse._implicitHeader (_http_server.js:157:8)
    at ServerResponse.end (/Users/Roller/Working/Web/mean-stack-relational/node_modules/compression/index.js:102:14)
    at writeend (/Users/Roller/Working/Web/mean-stack-relational/node_modules/express-session/index.js:257:22)
    at onsave (/Users/Roller/Working/Web/mean-stack-relational/node_modules/express-session/index.js:325:11)
    at .<anonymous> (/Users/Roller/Working/Web/mean-stack-relational/node_modules/express-sequelize-session/lib/e4store.js:90:51)
    at tryCatcher (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/util.js:16:23)
    at Promise._settlePromiseFromHandler (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/promise.js:504:31)
    at Promise._settlePromise (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/promise.js:561:18)
    at Promise._settlePromise0 (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/promise.js:606:10)
    at Promise._settlePromises (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/promise.js:681:18)
    at Async._drainQueue (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/async.js:138:16)
    at Async._drainQueues (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/async.js:148:10)
error:  RangeError: Invalid status code: 0
    at ServerResponse.writeHead (_http_server.js:192:11)
    at ServerResponse.writeHead (/Users/Roller/Working/Web/mean-stack-relational/node_modules/on-headers/index.js:55:19)
    at ServerResponse.writeHead (/Users/Roller/Working/Web/mean-stack-relational/node_modules/on-headers/index.js:55:19)
    at ServerResponse.writeHead (/Users/Roller/Working/Web/mean-stack-relational/node_modules/on-headers/index.js:55:19)
    at ServerResponse._implicitHeader (_http_server.js:157:8)
    at ServerResponse.end (/Users/Roller/Working/Web/mean-stack-relational/node_modules/compression/index.js:102:14)
    at writeend (/Users/Roller/Working/Web/mean-stack-relational/node_modules/express-session/index.js:257:22)
    at onsave (/Users/Roller/Working/Web/mean-stack-relational/node_modules/express-session/index.js:325:11)
    at .<anonymous> (/Users/Roller/Working/Web/mean-stack-relational/node_modules/express-sequelize-session/lib/e4store.js:88:51)
    at tryCatcher (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/util.js:16:23)
    at Promise._settlePromiseFromHandler (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/promise.js:504:31)
    at Promise._settlePromise (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/promise.js:561:18)
    at Promise._settlePromise0 (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/promise.js:606:10)
    at Promise._settlePromises (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/promise.js:685:18)
    at Async._drainQueue (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/async.js:138:16)
    at Async._drainQueues (/Users/Roller/Working/Web/mean-stack-relational/node_modules/bluebird/js/release/async.js:148:10)
Warning: Unexpected block "main"  on line 3 of /Users/Roller/Working/Web/mean-stack-relational/app/views/500.jade. This block is never used. This warning will be an error in v2.0.0

我试图删除数据库并创建一个新数据库，但仍然显示错误。

可能是什么问题？请建议。

谢谢

最佳答案

试试这个

ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

关于mysql - 无法输入 Unicode 数据、MySql、Express、M*EAN，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/38263704/

25 4 0
文章推荐： mysql - 如何检查MySQL中当前的MERGE_THRESHOLD值？
文章推荐： java - 在 OnCreateView 调用之外动态添加 View 到 fragment
文章推荐： android - Android 的 ARM 汇编程序中对 'printf' 的 undefined reference
文章推荐： javascript - 希望按子数组中的值对数组进行分组
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com