General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Codepage and ODBC on SQL Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only