CODEWITHSUNDEEP
sqlsql-server
Luke
Luke

Reputation: 409

Importing data using SQL Server Import Wizard results in weird characters

SQL Server 2016 Import and Export Wizard

Source IS Flat file (.txt):

enter image description here

enter image description here

Please note the data in column 3: it should read Île-de-France

Upvotes: 4

Views: 2220

Answers (2)

Luke
Luke

Reputation: 409

This is the correct procedure for importing tab-delimited text in utf8 encoding.

In the firs page of the Wizard, instead of checking "Unicode" (that's quite confusing because UTF-8 'is' Unicode) leave it unchecked and select Code page 65001

enter image description here

Now characters are being correctly visualized:

enter image description here

Upvotes: 2

Dhananjay Singh
Dhananjay Singh

Reputation: 161

This is Unicode Error that's y words is not showing properly. Go to the advance tab and select your third column as shown in fig: enter image description here

Choose data type string to "text stream [DT_TEXT]", If "text stream [DT_TEXT]" will not work then please try with other data type also. Ref this Fig :

enter image description here

Upvotes: 1

Related Questions