MySQL Forums
Forum List  »  InnoDB

Re: ENUM Restriction? Number of columns doesn't matter.
Posted by: Rick James
Date: January 10, 2009 12:46AM

Possibly: The fields of the ENUM are spelled out in the .frm, and the .frm is limited to 64K. This theory matches well with your statement -- about 6K of ~10 bytes each.

An unfortunate workaround: Shorten the names.

Another approach: Change the enums to SMALLINT and have a table mapping the nums to strings. (That is, no ENUM at all).

Options: ReplyQuote


Subject
Views
Written By
Posted
3004
January 06, 2009 02:38PM
1683
January 06, 2009 09:38PM
Re: ENUM Restriction? Number of columns doesn't matter.
1959
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.