The maximum field length in the imported set table has not work

[lipan]

Hi Everyone

issue：import set table‘s field max length is 4000,Importing strings exceeding 4000 characters without truncation

I created a table using load data, set the maximum length of each field, and then imported two data with a length equal to the maximum length of each field and a value that is 1 longer than the maximum length of the field. All other fields truncated the string to the maximum length normally, but the 'note' field did not, Characters that exceed the maximum length are still imported, Why 'note' field max length not work?

[Anand Kumar P · Accepted solution]

Hi @lipan ,

Refer below link

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0623379

Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand

[Hetang Modi]

Alternatively, if we set max length of a column of string type to 4000, ServiceNow would allow to save a string of length more than 4k, right, and up to 16MB characters, correct?

[shreyavashi]

Correct.

[Markus Kraus]

Had the same problem, only solution was to manually change the field length a few times... (I'm literally talking about changing it several times).

There is also a property involved with handling the import column size (com.glide.loader.verify_target_field_size):
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1588592

I've had two cases for this topic already but none of the solutions worked, and i restored into fiddling around with the column size until it worked because I couldn't wait for a in-depth analysis by SN's dev team...