General information
Title:
Problem reading NVARCHAR value from Oracle Database
Environment versions
Network:
Windows Server 2012 R2
Hi,
I have a product table in Oracle database which has a column (Prodname_ar) for storing product names in Arabic. My application uses English as Input language but wants to show some information in Arabic language.
I set "system locale" to "Arabic" and input language/Keyboard to "English" on my computer. I inserted Arabic text to Oracle database through sql pass through and it saved properly.
Now I read data but Sqlresult shows me "????????????" in Arabic column (Prodname_ar).
If I access this through ADO then I get Arabic text correctly.
How can I get this via sql pass through method form Oracle database ?
TIA
Naeem
Note: I also tested it using MS SQL Server and no problem getting Arabic text from nVarchar column via SPT.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only