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]

Reply via email to