Forum Moderators: coopster

Message Too Old, No Replies

Maximum number of values in an enum field?

database question

         

HughMungus

5:25 am on Apr 1, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I need to create an enum field. What's the maximum number of values (selections) I can put in there? Thanks.

HughMungus

5:42 am on Apr 1, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Well, I was able to put as many as I wanted to in there...but what is the maximum?

coopster

12:50 pm on Apr 1, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



For which database? MySQL?

An enumeration can have a maximum of 65,535 elements.

Resource:
The MySQL Manual ENUM [dev.mysql.com] page.