I have created a string attribute with a Maximum Size = 20. We want to reduce the maximum size from 20 to 14, but an error message appears. Why can't we change the size?
ERROR: ODF-0207 Data size cannot be reduced
The error message appears because the application prevents the loss of data within your database. Once a string attribute has been created, you can only increase the maximum size; you cannot decrease the maximum size.
One alternative is to create a new string attribute with the new maximum size and deactivate the existing attribute.