title: is it allowed to change enum field to text
body: <p>Maybe I am at the wrong stack, or this type of questions are not allowed.
  But I have a table.column which has as type ENUM with a lot of values.
  Since I try to change this (add more values) MariaDB server does not allow duplicate values. (MySQL server does)
  I was thinking can I change the type of the field to TEXT without any danger of changing data or be 'punished' in any other way?</p>
  <p>Removing duplicates are not possible cause there are 3 ENUM fields in the TABLE and the errors occurs in the 3 different fields.</p>