I have a field that should have been of type emun, but it was created as type text (I didn't create it, the person before me did)
Anyway, the database bas been populated with a lot of data.
However, the php script that inserts data into the database only insert the values of either A, B, or C. So, even though it's a text field, it's only values are A, B, or C. Hence, that's why I want to make it into a enum.
I want to know what the effects on currect data are if I were to change the field from type text to type enum ('A', 'B', 'C').
Would I loose the data?
Thanks,
Jason La
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
Anyway, the database bas been populated with a lot of data.
However, the php script that inserts data into the database only insert the values of either A, B, or C. So, even though it's a text field, it's only values are A, B, or C. Hence, that's why I want to make it into a enum.
I want to know what the effects on currect data are if I were to change the field from type text to type enum ('A', 'B', 'C').
Would I loose the data?
Thanks,
Jason La
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->