Strings shortened despite increasing max length of field

stopping
Giga Contributor

I'm running into an odd issue where increasing the maximum length of a string field has no effect on a table. For example, if I create a field which contains a string with a maximum length of 40, and then increase the limit to 100 after the table is created, I can now enter up to 100 characters for that field. However, when I make an update to a record or create a new one, strings are still truncated to 40 characters. I created a brand new table for testing, and I've found that the maximum length change is reflected in the database by looking at the table schema. When making an update using SQL directly, one can have strings which exceed the 40 character limit (such as using gs.sql('UPDATE ...'); ). When inserting or updating using GlideRecord, the strings are still shortened.

 

Any guidance is appreciated.

6 REPLIES 6

Thanks. In fact I removed the column and re added and pushed the changes again. Not the best approach but fixed the issue.


FYI... I found that using the "Form Design" option will properly update the change to the maximum length of a file.