ALTER TABLE: Data truncated on ENUM col

hi,

i have a ENUM col here and want to alter it:

ALTER TABLE `data_9` 
CHANGE `Which_OS_did_you_use` `Which_OS_did_you_use` 
ENUM('Win 95', 'Win 98', 'Win ME', 'Win 2000', 'Win XP')

Code (markup):

but i get a

Data truncated for column 'Which_OS_did_you_use' at row 1

Code (markup):

each time. no idea whats going on, can anyone tell me whats wrong in here?

 

Hello,
did you search here ?

http://dev.mysql.com/doc/refman/5.0/en/enum.html

Search on this page with your browser search, Data truncated for column

maybe this can help you

Best,
Jakomo

 

na, was looking for this problem but all i found was more or less "if you try to alter an enum type, you get the error 1265 (data truncated)" without any solution how to solve it.
the only thing i can do is to drop the column, create a new one and loose all the data.

 

Really I dont know, maybe you can create a tmp table, insert the information there, then alter the table, and then export again your info...