I'm updating all of my table fields with enum type to tinyint(1), but I'm seeing some strange behavior.
Say field_x type is enum('0','1','2')
;
After altering the table (ALTER TABLE a MODIFY field_x tinyint(1) NOT NULL DEFAULT 1
), fields with original value 0 now have 1, fields with original value 1 now have 2...
Does anybody know what is causing this?