On Thu, Jul 31, 2008 at 11:38 AM, Mr. Shawn H. Corey <[EMAIL PROTECTED]> wrote: > I don't see how that can be; with ENUM the DB has to set aside enough > bytes for the longest identifier.
ENUMs are stored as integers. > The only advantage of ENUM is that > the data is in the same table; you don't have to do an extra join. You don't have to join in order to use a lookup table. You can store the actual values in the column (unlike ENUM). - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]