MySQL Forums
Forum List  »  InnoDB

ENUM Restriction?
Posted by: Joseph Caristi
Date: January 06, 2009 02:38PM

In MySQL 5.0.45, I have a table with 55 columns, mostly ENUMS and tinyints. When I try to recreate the table, changing one varchar(100) field to an ENUM with 6452 entries, I get the message "Error Code : 1117 Too many columns."

Since I still only have 55 very short columns, why the error? Posts from earlier years alluded to some possible undocumented aggregate ENUM length, apart from the documentation stating that "An enumeration can have a maximum of 65,535 elements". Is this still the case? Does it change in version 5.1? I really want this ENUM!

Options: ReplyQuote


Subject
Views
Written By
Posted
ENUM Restriction?
3004
January 06, 2009 02:38PM
1683
January 06, 2009 09:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.