Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Issues with characters after load data

MARISA INACIO1
Tera Contributor

Hello everyone,

 

After performing a Load Data into an Import Set, there are certain characters that ServiceNow fails to read.
These are Portuguese characters.
However, for example, sometimes it reads the character "ê" correctly and other times it does not, which causes ServiceNow to create new columns and the Transform Map stops working.

I think this behavior might be related to ASCII character handling, but I do not know which character set ServiceNow uses internally.

I cannot find any official ServiceNow documentation explaining this behavior. Can you help?
u_rplcd_n_ascii

MARISAINACIO1_0-1765478045825.png

 

Thanks in advance,

Marisa

1 REPLY 1

MARISA INACIO1
Tera Contributor

Additionally, I identified that this issue started after we upgraded to the Xanadu release in March 2025. After the upgrade, ServiceNow began creating new columns for all Import Set tables that contain special characters in the column names.

 

MARISAINACIO1_0-1765480206924.png