ENUM Restriction?
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!
Subject
Views
Written By
Posted
ENUM Restriction?
3004
January 06, 2009 02:38PM
1683
January 06, 2009 09:38PM
1682
January 07, 2009 11:48AM
1577
January 07, 2009 08:29PM
1905
January 09, 2009 12:21PM
1960
January 10, 2009 12:46AM
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.