From: Martijn Tonies
Date: July 31 2008 1:51pm
Subject: Re: SET vs. ENUM
List-Archive: http://lists.mysql.com/mysql/213926
Message-Id: <029301c8f314$79b06d00$9902a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Jerry,

> 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?

Well, they are -different things- ...

SETs shouldn't be used at all, IMO.

ENUM can be somewhat useful, I guess.

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com