> > 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

Thank you so much for you reply. We are using Oracle 10g and I am using the instant client ODBC driver version 11.01.00.06. Here is my script to create the test table:

CREATE TABLE testTable (clobTest clob);
INSERT INTO testTable (clobTest) VALUES ('sdfaáááásadf');
COMMIT;

Then, from Foxpro, I do this:

lnhandle = SQLSTRINGCONNECT('Driver=Oracle in instantclient11_1;UID=username;PWD=password;DBQ=//DEVDB/MWTDEV.MIDWEST.LOCAL;')
? SQLEXEC(lnHandle, 'select * from testTable')
BROWSE

I do not see the accent characters in the Browse window or if I refer to the field directly.

I do not think I have any general VFP data configurations set differently from the default. What about you?