Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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


Former Member
replied

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.

3 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question