'latin-1' codec can't encode character 的解决方案
来源:互联网 发布:阿里云域名交易平台 编辑:程序博客网 时间:2024/05/22 10:30
分析一个字符串,并更新数据库的时候,出现了如下错误:
'latin-1' codec can't encode character u'\u017e' in position 11: ordinal not in range(256)
进行了一些研究发现,原因是,数据库的编码和数据源的编码不一致,并且包含了不能处理的字符。
有两种方法可用,一个是先预先处理一下字符串,二是设置数据库参数
1. 处理字符串
2. 设置数据库
'latin-1' codec can't encode character u'\u017e' in position 11: ordinal not in range(256)
进行了一些研究发现,原因是,数据库的编码和数据源的编码不一致,并且包含了不能处理的字符。
有两种方法可用,一个是先预先处理一下字符串,二是设置数据库参数
1. 处理字符串
- >>> u= u'hello\u2013world'
- >>> u.encode('latin-1','replace') # replace it with a question mark
- 'hello?world'
- >>> u.encode('latin-1','ignore') # ignore it
- 'helloworld'
- 或者根据需求进行处理
- >>> u.replace(u'\u2013','-').encode('latin-1')
- 'hello-world'
- If you aren't required to output Latin-1, then UTF-8 is a common and preferred choice. It is recommended by the W3C and nicely encodes all Unicode code points:
- >>> u.encode('utf-8')
- 'hello\xe2\x80\x93world
- db.set_character_set('utf8')
- dbc.execute('SET NAMES utf8;')
- dbc.execute('SET CHARACTER SET utf8;')
- dbc.execute('SET character_set_connection=utf8;')
0 0
- 'latin-1' codec can't encode character 的解决方案
- UnicodeEncodeError: 'latin-1' codec can't encode character
- UnicodeEncodeError: 'latin-1' codec can't encode character 报错
- 解决UnicodeEncodeError: 'latin-1' codec can't encode character
- UnicodeEncodeError: 'latin-1' codec can't encode character
- python mysql 'latin-1' codec can't encode character
- Python : UnicodeEncodeError: 'latin-1' codec can't encode character
- mysql 'latin-1' codec can't encode characters的问题
- python连接mysql 报'latin-1' codec can't encode character解决方法
- python mysql数据库 'latin-1' codec can't encode character错误问题解决
- python mysql数据库 'latin-1' codec can't encode character错误问题解决
- python mysqldb 数据库插入中文 “"UnicodeEncodeError:'latin-1' codec can't encode character ..."”
- python mysql数据库 'latin-1' codec can't encode character错误问题解决
- python mysqldb 数据库插入中文 “"UnicodeEncodeError:'latin-1' codec can't encode character ..."”
- Python, MySQLdb 编码问题 UnicodeEncodeError:'latin-1' codec can't encode character ...
- UnicodeEncodeError: 'latin-1' codec can't encode character '\u7537' in position 184: ordinal not in
- python3 pymysql 'latin-1' codec can't encode character 错误 问题解决
- python3 pymysql 'latin-1' codec can't encode character 错误 问题解决
- 断言ASSERT()是什么?
- caffe 多个cudnn
- Webstorm10.0.4 破解过程
- Mobile Movie Texture (Unity视频播放插件)
- struts2的文件上传
- 'latin-1' codec can't encode character 的解决方案
- HTTP Referer
- Android平台下利用zxing实现二维码开发
- Q55:字符流中第一个不重复的字符
- 敏捷开发之Scrum扫盲篇
- 一道可用背包问题解的华为编程题
- 系统托盘程序
- sql语句
- 最全加密算法之对称加密和非对称加密