String field changing the characters while doing a transformation

trinadh2
Giga Guru

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.

 

1 ACCEPTED SOLUTION

trinadh2
Giga Guru

The file that im loading is having the issue, the source file provided has made some changes while sending the file and the issue is fixed now. thank you:)

View solution in original post

9 REPLIES 9

Ankur Bawiskar
Tera Patron
Tera Patron

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi @Ankur Bawiskar ,

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

 

 

Hi,

which language is this? 박명선

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

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

 

Thank you