Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Importing data using SQL Server Import Wizard results in weird characters

Tags:

sql

sql-server

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

like image 549
Luke Avatar asked Oct 14 '25 04:10

Luke


2 Answers

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

like image 165
Luke Avatar answered Oct 16 '25 20:10

Luke


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

like image 34
Dhananjay Singh Avatar answered Oct 16 '25 19:10

Dhananjay Singh



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!