We have a column that is currently enum, containing a selection of possible choices that are at maximum 15 Chars.
We would like to change this column to be a Varchar(20), would this Alter keep the data in the current enum safe, that is convert them to be just Char data under the new Varchar(20) or will conversion from enum to Varchar cause the loss of data?
If yes, that is conversion from enum to varchat is not possible, what to you suggest as the best method to getting this objective realized?
I meant try as in: test. Make a backup first. Or create a test table. And see what happens.
Otherwise, you’ll have to wait for an answer a bit more, I wouldn’t know the answer