在使用pymysql查询时发生报错
UnicodeEncodeError: 'latin-1' codec can't encode character '\u3001' in position 85: ordinal not in range(256)
原因是pymysql默认的编码是latin,而我使用的是utf-8
链接方式改为:
db = pymysql.connect("localhost","root","password","test" ,use_unicode=True, charset="utf8")
添加 use_unicode=True, charset="utf8" 指定为utf-8编码.