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?
3014
January 06, 2009 02:38PM
1687
January 06, 2009 09:38PM
1685
January 07, 2009 11:48AM
1583
January 07, 2009 08:29PM
1907
January 09, 2009 12:21PM
1962
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.