坑爹的 ascii codec can't decode byte 0xc8
来源:互联网 发布:一维动态数组定义 编辑:程序博客网 时间:2024/06/05 21:59
用cx_Oracle 写update 语句,为了给参数加上单引号,所以就直接在 :1 之类的两边加上了 单引号,
结果一直报错 ascii codec can't decode byte 0xc8 之类的,还以为是编码问题,可是用debug看,都是string类型,百思不得其解
后来发现把 :1 :2 :3 之类两边的单引号去掉就可以了。。。。
currentTime = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')
updateSql ="update entrust set opp_serial_no =:1, report_time = to_date(:2, 'YYYY-MM-DD hh24:mi:ss')," + \
" close_time = to_date(:3, 'YYYY-MM-DD hh24:mi:ss'), status = '2'" +\
" where serial_no=:4"
cursor.execute(updateSql, (serialNumTo, currentTime, currentTime, serialNumFrom))
cursor.execute(updateSql, (serialNumFrom, currentTime, currentTime, serialNumTo))
囧。。原因就是其实是执行SQL语句错误,但是因为eric4的debug报错没有报最底层的错误,这个还有待研究
- 坑爹的 ascii codec can't decode byte 0xc8
- Anaconda Unicode DecodeError: 'ascii' codec can't decode byte 0xc8 in position 1
- UnicodeDecodeError: 'utf-8' codec can't decode byte 0xc8 in position 3: invalid continuation byte
- UnicodeDecodeError: 'utf-8' codec can't decode byte 0xc8 in position 12: invalid continuation byte
- python中运行错误: 'utf-8' codec can't decode byte 0xc8'
- unicodedecodeError:'ascii' codec cant decode byte 0xc8 inposition...
- 解决UnicodeDecodeError: ‘ascii’ codec can’t decode byte 0xe5
- 解决UnicodeDecodeError: ‘ascii’ codec can’t decode byte 0xe5
- Django UnicodeDecodeError: 'ascii' codec can't decode byte 0xe6
- Python “'ascii' codec can't decode byte 0xb0i in position 1” 的解决方法
- 解决 Python 出现的UnicodeDecodeError: 'ascii' codec can't decode byte 0xe9
- 解决 Python 出现的UnicodeDecodeError: 'ascii' codec can't decode byte 0xe9
- python3:SyntaxError: (unicode error) 'utf-8' codec can't decode byte 0xc8 in position xx: invalid co
- 原因和解决方案: ‘ascii’ codec can’t decode byte.
- Windows安装easy_install出错: 'ascii' codec can't decode byte
- pip UnicodeDecodeError: 'ascii' codec can't decode byte
- How to fix: “UnicodeDecodeError: 'ascii' codec can't decode byte”
- python UnicodeDecodeError: 'ascii' codec can't decode byte ...
- OpenCV中文网站上有讲怎么使用OpenCV读入和显示图像和视频
- QT样式图片范围设置
- 类:TMathParser
- MySQL-SQL语言入门
- java反射运用学习测试例子
- 坑爹的 ascii codec can't decode byte 0xc8
- c#学习(基础1)
- 在VS2005下使用Jrtplib传送H263视频(using OpenCV2.2)
- C语言中几个常量的区别
- Opencv + OpenNI + H.263 + RTP 视频截取、压缩和发送实验
- POJ-1132-Border
- (2)LPC2106 中断系统
- sqlite confict
- 一起学Lua(第二篇-环境搭建)