Why increased max length of string field is not working in ServiceNow?

[NK13]

By default string fields are created with max length of 40 characters, I tried updating max length of string field under "facilities_request" table to 120 with update set. After update it is accepting 120 characters but when I click on save, form reload and string field show only 40 characters.

I checked dictionary entry and it also shows max length 120 characters. At servicenow level it is taking 120 characters but at database level only store 40 charters. It took me around 30 mins to complete  the transaction of max length update.

• In lower environment I updated two string field lengths from 40 to 120 and captured in update set. it took me approx 50 mins to update both.
• Everything is working fine in lower env, but when I commit update set to Testing instance only one field working fine and other field only storing 40 characters and dictionary show both fields have max length 120.
• 20-30 mins to commit update set
• task table size: +6.8m

[rambo2]

both are same. either changing from dictionary or from here. will there be any impact ?

[NK13]

Hello Yousof,

Yes, we have tried form designer as well, not working. We have updated two string fields only one is working properly and other field not storing 120 characters it only stores first 40 character. 

when we check the dictionary entry it shows 120 max length.

Any other suggestion would be great.

[Supriya25]

did you find any solution for this ? how to increase max length 40 to 100 ?

[rexked]

For future reference field attribute "no_truncate" will override the system prop limit.