Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Codepage in query?

Status
Not open for further replies.

donnalee71

Programmer
Dec 16, 2002
5
US
Is there a way to specify a codepage in a query to a Clipper DBF file? I am trying to access some international data in a DBF from Visual Basic and the special characters are returning corrupted. I don't know anything about Clipper so I'm not sure how the files were created, just that the client works with them in Clipper.

Thanks!
 
You will have to use a DOS based codepage in VB, my first quess would be 850, but I have never used it, and never will, cause I'm not using VB. Probably someone with more VB knowledge can give a hint?

Grtz
 
Well, I know I have to use codepage 1252 but am not sure how to specify it in a SQL query to the DBF.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top