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.