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

Yes, I did the same (using "Toad"). Actually even the test-field name was the same :-)

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

Same here, exactly.

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

My Vfp IDE session was all-default here, too. It sounds like a codepage issue, doesn't it? There is a chapter "Invalid Data That Results from Setting the Client's NLS_LANG Parameter Incorrectly" in a Stanford.edu PDF http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10749.pdf
If that does not help, I can do more testing here.


hth
-Stefan