Hi Naeem,
only ADO supports UTF-8. Rick Strahl has a page on double-byte languages in VFP
https://www.west-wind.com/presentations/foxunicode/foxunicode.asp. Steven Black also have a page:
http://stevenblack.com/intlasia/The tool we found very handy was wwSQLClient from Rick's WestWind site. It's part of his Internet and Client Tools. You access ADO as you would a regular SQL query.
Finally: for display you will need controls that can show double-byte characters: DBI's Studio Controls for Com:
http://www.dbi-tech.com/ProductPage_StudioControlsCOM.aspx They have unicode versions of 19 of the controls.
In the end (after all the research and proofs-of-concept) we decided to go with Lianja for anything required asian/arabic double-byte languages, since Lianja is native UTF-8 and we are headed that way in any case. But if you are doing it in VFP, the above is what you need to know to get started.
Hank
>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.