使用vc code,编辑python对数据进行入库时,出现如下错误:
UnicodeEncodeError: 'charmap' codec can't encode characters in position 0-1: character maps to <undefined>
解决方法,在sql.py中,或者是链接数据库时,添加:最后增加一个 : charset="utf8" 就好了
database = MySQLdb.connect (host="localhost", user = "root", passwd = "root", db = "tpyuyue",charset="utf8")
如果是其他情况出现的,可使用:
create_engine('mysql+mysqldb://USER:@SERVER:PORT/DB?charset=utf8', encoding='utf-8')