Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Toni Feltman
  Where is Toni Feltman?
 Toledo
 Ohio - United States
 Toni Feltman
 Tags
Subject: FoxPro / ORACLE / ODBC / Foreign
Thread ID: 202066 Message ID: 202066 # Views: 78 # Ratings: 0
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Wednesday, November 05, 2008 6:15:15 PM         
   


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-



COMPLETE THREAD
FoxPro / ORACLE / ODBC / Foreign Posted by Toni Feltman @ 11/5/2008 6:15:15 PM
RE: FoxPro / ORACLE / ODBC / Foreign Posted by Stefan Wuebbe @ 11/7/2008 10:00:57 AM
RE: FoxPro / ORACLE / ODBC / Foreign Posted by Toni Feltman @ 11/10/2008 4:17:20 PM
RE: FoxPro / ORACLE / ODBC / Foreign Posted by Stefan Wuebbe @ 11/11/2008 7:11:12 AM
RE: FoxPro / ORACLE / ODBC / Foreign Posted by Toni Feltman @ 11/12/2008 5:26:16 PM
RE: FoxPro / ORACLE / ODBC / Foreign Posted by Stefan Wuebbe @ 11/12/2008 5:30:08 PM