Details
Description
I recently had to increase the length of a custom field. On the actual table holding the custom field, it correctly went from VARCHAR(255) to VARCHAR(510). The length was not automatically changed in the corresponding log table, which remained at 255, requiring an ALTER TABLE command.
This represents a possible loss of future log data if data long enough to require the increased length is then entered without manually making the change to the log table.
Fixing this only applies to increases. If a field is decreased in length we probably don't want to reflect that in the log as it could truncate existing log data.
Also, in my case the field in question was a multiple-choice set of checkboxes with an option group. I found it a bit odd that the text length of the field was an option in this case.