Wednesday, March 28, 2012

importing text in SQL server

I need to import a large textfile into sql server 2005.
Some of the text fields contain special characters...like:

?le-de-France


when I import a text like this into SQL Server I get:
??le-de-France

What can I do to prevent this from happening? (other fieldtype?)Using Unicode is a good choice...That maps to NTEXT data type in SQL Server|||Using Unicode is a good choice...That maps to NTEXT/NVARCHAR data type in SQL Server|||Could you please describe the steps I need to take to make this work?
I cant get it done..:$...sql

No comments:

Post a Comment