String field changing the characters while doing a transformation

[Community Alums]

Hi,

We have a String field in our staging and target table which has to copy the value from the sheet. when we are loading the data(transform map) it is changing the value which is being sent Example: if the value is like this 박명선 it is converting it something like l朱æ•�. When tried to updated the field manually it is getting copied correctly. Not sure what is causing the issue. We have the Chinese Translation in our instance   

@Ankur Bawiskar  could you please help me on this.

Thank you.

[Ankur Bawiskar]

Hi,

seems the data while loading into import set is getting corrupted due to character encoding.

ServiceNow supports UTF-8.

Please check that in your excel then

Regards
Ankur

[Community Alums]

Hi @Ankur Bawiskar ,

I The Excel file that we are importing is UTF8 only but still it is the same.

[Ankur Bawiskar]

Hi,

which language is this? 박명선

Regards
Ankur

[Community Alums]

@Ankur Bawiskar  its chinese language and chinese Translation is there in our instance

Thank you