Home » Infrastructure » Windows » Arabic text saved using odp in varchar2 field becomes '????'
Arabic text saved using odp in varchar2 field becomes '????' [message #488283] Thu, 06 January 2011 02:52 Go to next message
julb
Messages: 17
Registered: November 2010
Junior Member
Hi,

we have 2 databases with AR8MSWIN1256 characterset (arabic).
our client machine has English windows installed.
our .NET application, which runs on the client machine, using ODAC and it reads and writes from one db to another db.
We have no problems with nvarchar fields containing arabic, but with varchar fields it seems that it reads the data just fine - we can see it in GUI.but when it writes the data to the second db, arabic becomes question marks.
We tried to set client NLS_LANG in registry to AR8MSWIN1256 and to WE8MSWIN1252. It doesnt help.
What else can cause this behavior?

Thanks.
Re: Arabic text saved using odp in varchar2 field becomes '????' [message #488332 is a reply to message #488283] Thu, 06 January 2011 09:03 Go to previous messageGo to next message
BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal
Senior Member
do you have data storage or data presentation problem?
each requires different solution

SELECT ASCIISTR(ARABIC_COLUMN) FROM SAMPLE_TABLE WHERE ID = <KEY>;

issue SQL against both DB which should contain same data.
If results are the same, you have data presentation problem.
If different, data storage problem exists.
Re: Arabic text saved using odp in varchar2 field becomes '????' [message #488333 is a reply to message #488332] Thu, 06 January 2011 09:05 Go to previous messageGo to next message
julb
Messages: 17
Registered: November 2010
Junior Member
I have data saving problem. The presentation is ok.
Re: Arabic text saved using odp in varchar2 field becomes '????' [message #488334 is a reply to message #488333] Thu, 06 January 2011 09:07 Go to previous messageGo to next message
BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal
Senior Member
>I have data saving problem.
requires fixing the code that loads data into second DB.
Re: Arabic text saved using odp in varchar2 field becomes '????' [message #488336 is a reply to message #488334] Thu, 06 January 2011 09:11 Go to previous message
julb
Messages: 17
Registered: November 2010
Junior Member
Really???
Why bother answering if you don't understand the issue?

Thanks anyway...
Previous Topic: Oracle 10g ODAC error
Next Topic: ORACLE 11g R1 or R2 for Window Server 2008 R2
Goto Forum:
  


Current Time: Sat Dec 05 12:34:55 CST 2020