Hi,

I have a ODBC link with a non fospro DBF on a SQL server (a linked server). This DBF have accentuated chars like (é, É, à, À,...) the codepage of this DBF is 850. Using this DBF with Foxpro is easy, I simply use CPCONVERT(850, 1252, fieldname) to retreive accentuated chars.

How can I do that with SQL Server? there is no parameters about codepage in function OPENQUERY and all accentuated chars are replaced with a square.

Thanks