June 1, 2007 at 9:58 am
I have a Visual FOXPRO table that I would like to import in SQL Server 2000. I have created a linked server for the DBF table, but when importing into SQL, my French characters got screwed up.
My SQL database collation is SQL_LAtin1_General_CP1_CI_AS.
When creating the linked server, I used different collations, including the same as the SQL database. None of them worked.
Any idea what collation I should use for the linked server? Or any idea?
Thanks.
June 19, 2007 at 8:47 am
I don't know about the collation but if you are trully just wanting to import the data into SQL-Server 2000, you might look at using the DTS Import/Export Wizard.
Steve
June 21, 2007 at 12:49 am
are you importing into sql or you are using a linked server and using that in your queries.
if you are definately importing you can use the suggestion above i.e. use the DTS import wizard.
is you are using a linked server, then in your queries you can set the collation
June 21, 2007 at 1:46 am
The better option is to move using DTS to move the data. And regarding the collation you can set the collation to French base in your sql server and move the data check whats the name of the collation you want.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply