Incorrect string value: '\\xE7\\x9B\\xB8\\xE5\\x90\\x8C...' for column 'comment' at row 1
来源:互联网 发布:php aes解密后有乱码 编辑:程序博客网 时间:2024/05/04 11:35
问题:
前端POST请求中包含中文内容时,出现如下错误:
Exception Type: OperationalError at /api/notification/eventadjustment/
Exception Value: (1366, “Incorrect string value: ‘\xE7\x9B\xB8\xE5\x90\x8C…’ for column ‘comment’ at row 1”)
或者django 修改用户时的报错
OperationalError at /api/admin/auth/user/2/
(1366, “Incorrect string value: ‘\xE6\xB2\xA1\xE6\x9C\x89…’ for column ‘change_message’ at row 1”)
或者
OperationalError at /api/admin/auth/group/add/
(1267, “Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘=’”)
原因:
后台DB表及字段编码问题。
解决办法:
首先,设置表的编码utf8。
ALTER TABLE orange CHARACTER SET = utf8 ;
其次,设置字段的编码utf8。
ALTER TABLE orange CHANGE COLUMN `comment` `comment` VARCHAR(255) SET 'utf8' NOT NULL DEFAULT '' ;
0 0
- Incorrect string value: '\\xE7\\x9B\\xB8\\xE5\\x90\\x8C...' for column 'comment' at row 1
- ERROR 1366 (HY000): Incorrect string value: '\xE4\xB8\xAD\xE5\x9B\xBD' for column 'tname' at row 1
- mysql:Incorrect string value: '\xE5\x8C\x97\xE4\xBA\xAC' for column 'address' at row 1
- Incorrect string value: '\xE4\xB8\xAD\xE7\xBA\xA7' for column 'title' at row 1
- Incorrect string value: '\xE4\xB8\x80\xE7\xBA\xA7...' for column 'name' at row 1
- ERROR 1366 (HY000): Incorrect string value: '\xE5\xB8\x82' for column 'address' at row 1
- ERROR 1366 (HY000): Incorrect string value: '\xE5\xB8\x82' for column 'address' at row 1
- failed:Incorrect string value: '\xE5\xBC\xA0\xE4\xB8\x89' for column 'name' at row 1
- Incorrect string value: '\xE7\x94\x98\xE5\xB7\x9E...' for column 'SystemName' at row 1
- Incorrect string value: '\xE7\xA8\x8B\xE5\xBA\x8F...' for column 'course' at row 1
- node.js Incorrect string value: '\xF0\x9F\x92\x9E\xE5\x9B...' for column 'nickname' at row 1
- Mysql 插入中文错误:Incorrect string value: '\xE7\xA8\x8B\xE5\xBA\x8F...' for column 'course' at row 1
- Sqlyog中解决编码问题Incorrect string value: '\xE7\xA8\x8B\xE5\xBA\x8F...' for column 'course' at row 1
- Mysql 插入中文错误:Incorrect string value: '\xE7\xA8\x8B\xE5\xBA\x8F...' for column 'course' at row 1
- Mysql 插入中文错误:Incorrect string value: '\xE7\xA8\x8B\xE5\xBA\x8F...' for column 'course' at row 1
- Incorrect string value: '\xF0\x9F\x92\x90</...' for column 'xxx' at row 1
- Incorrect string value: '\xF0\x9F\x92\x90</...' for column 'xxx' at row 1
- Incorrect string value: '\xF0\x9F\x90\x9D</...' for column 'content' at row 1
- 【Unity优化】构建一个拒绝GC的Lis
- vim grep配置及使用
- JS实现顺时针打印数组
- 2017/3/18 CSP题库的一道不算很难的题 因为自己没认真看题被坑惨..
- 使用Vim
- Incorrect string value: '\\xE7\\x9B\\xB8\\xE5\\x90\\x8C...' for column 'comment' at row 1
- 使用Eclipse创建包
- 01 了解activity
- Vim winmanager文件浏览自动更新
- 单例模式(2-设计模式)
- C++ main函数中参数argc和argv含义及用法
- 衡量回归模型的效果--R语言实现
- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- 蓝以中老师《高等代数》第01章:代数学的经典课题,笔记