On Thu, Jul 31, 2008 at 9:46 AM, Jerry Schwartz <[EMAIL PROTECTED]> wrote: > Other than the fact that an ENUM can have many more values than a SET, is > there any particular reason to choose one over the other?
The only use for ENUM is to make your data smaller. It offers no protection against illegal values and can't be updated without copying the table. If you want to constrain values, a better approach is to make your tables InnoDB and use a lookup table with a foreign key constraint. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]