Re: SET vs. ENUM

[Perrin Harkins]

On Thu, Jul 31, 2008 at 11:38 AM, Mr. Shawn H. Corey
<shawnhcorey@stripped> 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