UnicodeEncodeError: ‘charmap‘ codec can‘t encode characters in position 0-1: character maps to ＜unde_unicodeencodeerror: 'charmap' codec can't encode c

作者：一键难忘520 | 2024-06-24 03:45:58

踩

unicodeencodeerror: 'charmap' codec can't encode characters in position 0-1:

使用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')

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/一键难忘520/article/detail/751562