worldnews — 2010-07-27T00:46:45-04:00 — #1
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?
guido2004 — 2010-07-27T02:52:26-04:00 — #2
worldnews — 2010-07-27T10:45:45-04:00 — #3
I have been waiting for replies here as to whether the data will be Ok going
from enum to Varchar or not.
If not, then I would not want to try
guido2004 — 2010-07-27T10:53:33-04:00 — #4
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
r937 — 2010-07-27T11:15:08-04:00 — #5
i don't know the answer either
in order to test it, i'd have to build the table
but since you already have such a table, worldnews, you could test it for us and let us know
don't forget to take a backup first