Changing the max length for the label field on the sys_choice table through an update set to a value larger than 100 - Support and Troubleshooting

Changing the max length for the label field on the sys_choice table through an update set to a value larger than 100 Issue  Changing the max length on the dictionary records for the label field on sys_choice table to a value larger than 100 will work when making the change directly in an instance. However, when trying to move that change via update set the change will not reflect and even though the max length size will display the new value, the data stored in the label column from sys_choice table will be truncated to 100 characters.

Cause The sys_choice table is a core table and is blacklisted form making changes via update set. This is why the update set will not be successful when attempting to change the max_length.

Resolution It is never a good idea to alter core system tables, but if it is strictly necessary, then the change can be done in each instance, directly through the UI, not via update sets.