"UnicodeEncodeError:‘latin-1‘ codec can‘t encode character ..."
This is because MySQLdb normally tries to encode everythin to latin-1. This can be fixed by executing the following commands right after you‘ve etablished the connection:
db.set_character_set(‘utf8‘) dbc.execute(‘SET NAMES utf8;‘) dbc.execute(‘SET CHARACTER SET utf8;‘) dbc.execute(‘SET character_set_connection=utf8;‘)
意思就是MySQLdb正常情况下会尝试将所有的内容转为latin1字符集处理"db" is the result of MySQLdb.connect, and "dbc" is the result of db.cursor().
db是connection连接，dbc是数据库游标
http://stackoverflow.com/questions/3942888/unicodeencodeerror-latin-1-codec-cant-encode-character
【转】python mysql数据库 'latin-1' codec can't encode character错误问题解决
原文：https://www.cnblogs.com/jlf0103/p/9021092.html