解决pymysql 插入数据时报错 UnicodeEncodeE

解决这个问题的核心代码:

db.set_charset('utf8')

如果你的数据库编码也是utf8

完整代码

    def saveData(self, sql):
        db = self.connectMysql()
        db.set_charset('utf8')
        try:
            cursor = db.cursor()
            cursor.execute(sql)
            db.commit()
            id = cursor.lastrowid
        except pymysql.Warning as w:
            db.rollback()
            print(repr(w))
            id = 0
        db.close()
        return id