Skip to Content
avatar image
Former Member

How to resolve if the Special characters are changed when loading the data from excel file to SQL table

Hi Experts,

I have a scenario as below.

My source is excel file and which is having customer master data. In that Name1 filed is having some special characters (symbols which are not part of our keyboard, like company registered symbol, R in the circle, pound symbols) .

The above data when I am extracting from the excel file and loading into my Target SQL server table, the special characters (symbols) are getting changed.

Only the special charaters are getting changed and remaining characters are displaying as expected.

I tried to resolve this by saving the excel file encoding as UTF-8 and creating the Target datastore code page and server codepage using UTF-8, but no luck.

Please suggest me how to resolve this issue.

Regards,

Vijay Bhaskar


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 21, 2014 at 08:36 PM

    Hi Former Member

    First make your source Code-page to UTF-16.

    and in target table double click and scroll down to bottom

    in miscellaneous select Yes to use VARCHAR as NVARCHAR in supported Database.

    Output:

    Regards,

    Akhileshkiran.

    Add comment
    10|10000 characters needed characters exceeded