From: Martijn Tonies
Date: November 28 2005 4:39pm
Subject: Re: Seeking Opinions
List-Archive: http://lists.mysql.com/mysql/192267
Message-Id: <0b0101c5f43a$52f7cfe0$cd02a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit




> Part of me agrees with you, on a "Pure SQL level". but then why would
> anyone ever use ENUM or SET?

I wouldn't :-)

IMO, they're abominations that are to be avoided.

Now, ENUM could be a bit useful. The Pure SQL way to avoid those
would simply be a column of the right datatype and a CHECK constraint
(which MySQL doesn't support, yet).

--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com