OraFAQ Forum: Windows » Arabic text saved using odp in varchar2 field becomes '????'

Home » Infrastructure » Windows » Arabic text saved using odp in varchar2 field becomes '????'

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Arabic text saved using odp in varchar2 field becomes '????' [message #488283]

Thu, 06 January 2011 02:52

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.

Report message to a moderator

Re: Arabic text saved using odp in varchar2 field becomes '????' [message #488332 is a reply to message #488283]

Thu, 06 January 2011 09:03

BlackSwan
Messages: 26766
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.

Report message to a moderator