python mysql 1366, u"Incorrect string value: '\\xF0\\x9F\\x98\\x8A' for column 'content' at row 1"
来源:互联网 发布:微信转换淘宝链接 编辑:程序博客网 时间:2024/05/17 08:53
方法一:(PS 网上基本上说的是这个方法)
comment['content'] = '傻大个数据的护额我' #随意写的一些内容#插入数据库的时候,会提示错误的字符值#comment['content']是插入数据库的值#修改后的代码points = re.compile(u'[\uD800-\uDBFF][\uDC00-\uDFFF]')points.sub(u'', comment['content'])comment['content'] = points
方法二:(这个是自己碰到的一个情况,方法一无法解决)
comment['content'] = '惊讶傻大个数据的护额我' #随意写的一些内容#插入数据库的时候,会提示错误的字符值content = comment['content'].encode("utf-8")#修改后的代码if "\xf0\x9f" in content: num = detailAddress.count("\xf0\x9f") for x in range(num): content= content.replace( content[content.find("\xf0\x9f"):content.find("\xf0\x9f") + 4], "")else: content= contentcomment['content'] = content
阅读全文
0 0
- python mysql 1366, u"Incorrect string value: '\\xF0\\x9F\\x98\\x8A' for column 'content' at row 1"
- java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\xB3' for column 'Content' at row 1
- Incorrect string value: '\xF0\x9F\x98\x8A. ...' for column
- Incorrect string value: '\xF0\x9F\x98\x92' for column 'NIKENAME' at row 1;
- java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x8E' for column 'nick' at row 1
- 彻底解决:Incorrect string value: '\xF0\x9F\x98\xAD",...' for column 'commentContent' at row 1
- mysql General error: 1366 Incorrect string value: '\xF0\x9F\x91\x8D\xF0\x9F...' for column 'dianpumiaoshu' at row 1 解决方法
- Incorrect string value: '\xF0\x9F\x90\x9D</...' for column 'content' at row 1
- mysql:Incorrect string value: '\xF0\x9F\x98\xB8' for column
- Incorrect string value: '\xF0\x9F\x91\x93\xF0\x9F...' for column 'xxx' at row 1
- Incorrect string value: '\xF0\x9F\x92\x90</...' for column 'xxx' at row 1
- 保存数据时报:Incorrect string value: '\xF0\x9F\x91\x8D' for column 'f_char_name' at row 1
- Incorrect string value: '\xF0\x9F\x92\x90</...' for column 'xxx' at row 1
- 该错误的解决办法:Incorrect string value: '\xF0\x9F...' for column 'XXX' at row 1
- Mysql 插入 Emoji表情报错 Incorrect string value: '\xF0\x9F...' for column 'XXX' at row 1
- 解决mysql插入数据时出现Incorrect string value: '\xF0\x9F...' for column 'name' at row 1的异常
- Mysql 插入 Emoji表情报错 Incorrect string value: '\xF0\x9F...' for column 'XXX' at row 1
- mysql Incorrect string value \xF0\x9F\x98\x84\xF0\x9F
- 343. Integer Break 题解
- HTML 颜色色号
- hdu3613(Manacher)
- 不能将CSV复制到postgreSQL表中:列不接受空字符串
- document常用方法
- python mysql 1366, u"Incorrect string value: '\\xF0\\x9F\\x98\\x8A' for column 'content' at row 1"
- webservice和socket服务的区别
- 【java-分布式系统】消息中间件学习
- history对象
- Centos7 安装图形化界面&远程桌面
- Ubuntu安装opencv3.2.0和contrib
- 纸牌游戏--小猫钓鱼
- zookeeper原理
- Android Studio中绘制UML类图介绍