python mysql数据库 'latin-1' codec can't encode character错误问题解决

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

"UnicodeEncodeError:'latin-1' codec can't encode character ..."

This is because MySQLdb normally tries to encode everything to latin-1. This can be fixed by executing the following commands right after you've etablished the connection:

意思就是MySQLdb正常情况下会尝试将所有的内容转为latin1字符集处理

所以处理方法就是，设置连接和游标的charset为你所希望的编码，如utf8。

db.set_character_set('utf8')

dbc.execute('SET NAMES utf8;') dbc.execute('SET CHARACTER SET utf8;')

dbc.execute('SET character_set_connection=utf8;')

db是connection连接，dbc是数据库游标

http://stackoverflow.com/questions/3942888/unicodeencodeerror-latin-1-codec-cant-encode-character