oracle数据库中的阿拉伯字符 [英] arabic characters in oracle database

问题描述

我想在我的数据库中存储阿拉伯字符，但是它们存储的问题就是这样吗？ ????。我试过这些功能：

  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屋！