It would be a nice feature to automatically add an upper limit on size restricted fields (ie. if the sys_title has a size of 1024, then it should automatically set/create a validation rule that says that the number of character input cannot be greater than that).
I really don’t think it is that practical to go through all the fields and manually add validation rules when you have already restricted the field size.
I agree. It would be nice if it would add those validators for you, especially since if you don’t add the validation and someone puts in too long a value, the error message that results is not helpful or friendly for the end user.
There, to my knowledge, is no documentation on this so it is easy to miss. Especially as validation rules are hidden away in a separate dialog. You can end up with a system full of mismatched validation rules and storage sizes. We certainly have.
Also, MSM will complain when you copy this change over, if existing content exceeds the new limit. You need to trim the content with an SQL statement such as:
UPDATE <tablename> SET <fieldname> = SUBSTR(<fieldname>, 1, <newsize>)
WHERE LENGTH(<fieldname>) > <newsize>