使用第三方短信平台,接受回复信息,内容存入数据库乱码,使用content.encode('utf-8')转码报错
错误信息:'utf8' codec can't decode byte 0xcc in position 0: invalid continuation byte
代码:def recvsms(password = __password):
data = {}
data['uid'] = '205020'
data['pwd'] = __md5(password)
url = 'http://101.201.41.56:9885/c123/recvsms'
try:
cnn_base_info=mysql_conn.get_conn(db_config.config_base_info)
if cnn_base_info == None:
__write_warn("can't get connection of notify","__process_mails")
return
cursor_base_info=cnn_base_info.cursor(dictionary=True)
resms = __do_get_recvsms(url,data)
resList = resms.split("{&}")
for res in resList:
if "||" not in res:
continue
cellnumber = res.split("||")[0]
content = res.split("||")[1]
sql_insert_recvsms = '''
insert into recvsms(cellnumber,smscontent,status) VALUES(%s,%s,%s)
'''
cursor_base_info.execute(sql_insert_recvsms,(cellnumber,content.encode('utf-8'),0))
cnn_base_info.commit()
return True
except Exception, e:
print (e)
return False
finally:
cnn_base_info.close()
cursor_base_info.close()