Python Code

sql = "INSERT INTO test(keyword,content) values(\"%s\",\"%s\")"%(keyword,content)
cur.execute(sql)

报错信息

File "D:\Personal\Common.py", line 72, in DataIntoDB
cur.execute(sql)
File "D:\Python\V2.7\lib\site-packages\MySQLdb\cursors.py", line 157, in execute
query = query.encode(charset)
UnicodeEncodeError: 'gbk' codec can't encode character u'\u2027' in position 185: illegal multibyte sequence

参考文章

Python字符编码详解
Python当前的默认编码设置setdefaultencoding
Python中如何处理UnicodeDecodeError和UnicodeEncodeError
Python 2.x中常见字符编码和解码方面的错误及其解决办法
Python中字符编码的总结和对比：Python 2.x的str和unicode vs Python 3.x的bytes和str