String and Max length

[yandp]

Hi all,

i have custom table with the field type as below

When i load data from excel to this table , the data for this this field only accepted 40 characters.
but when i manually input to the field, i am ok to save the data >40 characters.
what is the meaning of this max length? what is the relation?
if i need to increase number of character , how can i do it? changing the max length have any impact to existing data?

Please share with me any info how to resolve this. 
Thank you very much in advance. 

[Community Alums]

It's advisable to consider Tony Barratt's approach; you can find his comment in the following link. https://community.servicenow.com/community?id=community_question&sys_id=5526cf61db1cdbc01dcaf3231f96...

[yandp]

@Community Alums 
Thank you for the help.

Best regards.

[yandp · Accepted solution]

Thank you for members help here.

i had resolved this case by referring to this. 
https://www.servicenow.com/community/developer-forum/easy-import-truncating-reference-field-value-to...

Set the field max length in the import table that help the case. Thank you so much.