ORA-29275: partial multibyte character
来源:互联网 发布:东北 校园网络电视 编辑:程序博客网 时间:2024/05/30 04:17
查询oracle数据库中的一个字段时爆出了这个错ORA-29275: partial multibyte character
sql语句
select a.zymcfrom sd_zy.xxxx a
当查询其他字段时都不会报错,唯独查询这个字段报错
上网查询了很多资料
you should use SUBSTRB
when you copy your data from your 250 CHAR
column to your 250 byte
column. This function will only output whole characters (you won't get incomplete unicode characters):
这个答案还是蛮靠谱的
我将sql语句改成如下所示:
select substr(a.zymc,1,9) ch9 from sd_zy.xxxx a
ok!
阅读全文
0 0
- ORA-29275: partial multibyte character
- ORA-29275: partial multibyte character
- Multibyte-character processing in J2EE
- AJAX and Multibyte Character Support
- Multibyte character exploits - PHP/MySQL
- warning: #870-D: invalid multibyte character sequence
- warning: #870-D: invalid multibyte character sequence
- [Linux]: rar e Invalid or incomplete multibyte or wide character
- cmd 远程执行linux脚本提示 invalid multibyte character
- MFC对Unicode与Multibyte Character Set(MBCS)的支持
- UnicodeEncodeError: ‘gbk’ codec can’t encode character ****: illegal multibyte sequence
- UnicodeEncodeError: 'gbk' codec can't encode character: illegal multibyte sequence
- ORA-00911: invalid character
- ORA-00911: invalid character
- ORA-00911: invalid character
- ORA-00911: invalid character
- ORA-00911: invalid character
- converting to execution character set: Invalid or incomplete multibyte or wide character
- oracle数据库笔记一
- 找工作历险记:位运算篇
- Android应用中去掉标题栏的方法
- Spring如何解决循环依赖
- RecyclerView 列表无法显示或者显示不正常
- ORA-29275: partial multibyte character
- oj 结尾0的个数
- oracle知识点(一)
- 梯度、散度、旋度、拉普拉斯算子、高斯散度定理
- 安卓学习笔记(2)- SQLite中使用query函数对某类数据进行排序
- Python学习笔记:Python网络爬虫,实现爬取网络图片
- 微信端开发配置
- 心急的C小家
- VC6在64位Win7下调试无法退出