> Ok, so what I am I missing. When I execute the following code against my Oracle database using SQL Developer (Oracle SQL tool)
>
> SELECT NewLongDesc FROM product WHERE Stk_Num = 'YYU58949441A';
>
> I get results like this.
>
> sdfaáááásadf
>
> When I execute the same in Fox, I get this.
>
> sdfaaaaasadf
>
> I tried SYS(987). The field is a NCLOB in Oracle but I have a similar problem with a CLOB. I know that this is a codepage/translation...etc issue but I can't figure out what setting I need to change.
>
> Thanks so much in advance!

Toni,

What is your Oracle DB and ODBC driver version?

(Just made a test with a testTable.clobTest in Oracle 10g containing your string and got it back as it is via SPT in Vfp thru Oracle Client ODBC (sqora32.DLL) version 10.01.00.30)


Regards
-Stefan