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字符集处理