1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

ALTER TABLE: Data truncated on ENUM col

Discussion in 'MySQL' started by falcondriver, Sep 6, 2007.

  1. #1
    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?
     
    falcondriver, Sep 6, 2007 IP
  2. jakomo

    jakomo Well-Known Member

    Messages:
    4,262
    Likes Received:
    82
    Best Answers:
    0
    Trophy Points:
    138
    #2
    jakomo, Sep 6, 2007 IP
  3. falcondriver

    falcondriver Well-Known Member

    Messages:
    963
    Likes Received:
    47
    Best Answers:
    0
    Trophy Points:
    145
    #3
    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.
     
    falcondriver, Sep 6, 2007 IP
  4. jakomo

    jakomo Well-Known Member

    Messages:
    4,262
    Likes Received:
    82
    Best Answers:
    0
    Trophy Points:
    138
    #4
    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...
     
    jakomo, Sep 6, 2007 IP