作者:膈应人的ID | 来源:互联网 | 2018-06-05 10:03
UnicodeEncodeError:latin-1codeccantencodecharacter...ThisisbecauseMySQLdbnormallytriestoencodeeverythintolatin-1.Thiscanbefixedbyexecutingthefollowingcommandsrightafteryouveetablishedtheconnection:db.s
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 . s
"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;')
"db" is the result of MySQLdb.connect, and "dbc" is the result of db.cursor().
意思就是MySQLdb正常情况下会尝试将所有的内容转为latin1字符集处理