Hi,
Have you tried changing the SQL server regional settings? Also checkout 'SQL Collations' in the HELP.
HTH,
Arriyel
>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
Speak using soft and sweet words in case you have to eat them later.