oracle数据库中的阿拉伯字符 [英] arabic characters in oracle database
本文介绍了oracle数据库中的阿拉伯字符的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想在我的数据库中存储阿拉伯字符,但是它们存储的问题就是这样吗? ????。我试过这些功能:
msg_txt:= convert(msg_txt,'AR8MSWIN1256','AR8ISO8859P6');
但我收到此错误:
ORA-01858:找到一个非数字字符,其中有一个数字
任何建议?
谢谢
解决方案
是你的数据库和国家字符集?如果您不确定
SELECT *
FROM v $ nls_parameter
WHERE名称LIKE'%CHARACTERSET '
msg_txt变量的数据类型是什么? CHAR / VARCHAR2?或NCHAR / NVARCHAR2?
Dear all, I am trying to do the following.
I want to store Arabic characters in my database but the problem they are stored like that '??? ????'. I have tried with these function:
msg_txt:=convert(msg_txt, 'AR8MSWIN1256', 'AR8ISO8859P6');
but I got this error:
ORA-01858: a non-numeric character was found where a numeric was expected
any suggestion please?
thanks
解决方案
What is your database and national character set? If you're not sure
SELECT *
FROM v$nls_parameter
WHERE name LIKE '%CHARACTERSET'
What is the data type of the msg_txt variable? CHAR/ VARCHAR2? Or NCHAR/ NVARCHAR2?
这篇关于oracle数据库中的阿拉伯字符的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文