Question Marks for special Characters After Data Import in ServiceNow - Encoding Issue?

[prasanththo]

Hello everyone,

I'm encountering an issue with special characters (such as accents, umlauts, etc.) appearing as question marks(?) after importing data into ServiceNow. Specifically, I noticed that characters like à , é , ü and ß are not displaying correctly, and are being replaced with question marks when viewed in the records.

I would greatly appreciate any insights or suggestions you might have. Thank you in advance!

[Ankur Bawiskar]

@prasanththo 

Seems the data in those excel/csv cells is not UTF and hence the weird characters.

Did you check the staging table has same weird characters?

[Ankur Bawiskar]

@prasanththo 

this KB also talks the same what I mentioned. the character set should be UTF-8 or windows-1252
special character (i with accent) is not imported in staging table 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@prasanththo 

Did my reply answer your question?

If my response helped please close the thread by marking appropriate response as correct so that it benefits future readers.