How to change
CHAR (17 byte) to
CHAR (16 byte) when there is already a data?
Values are something like this:
- There is a space at the end.
I tried to trim it first before altering the column size but still gets the error due to column is already bigger than 16 byte (due the space at the end).