On Dec 7, 2005, at 10:10 AM, AgentM wrote: > MySQL has an ENUM feature, but I strongly advise you not to use it.
Actually, MySQL supports both ENUM and SET[1], which are similar in properties. > Put the possible values in a separate table make use a foreign key to > link it to the main table (if your version supports such a thing...). > This is proper normalization and allows you to add or delete values > without modifying a fragile datatype. > > http://dev.mysql.com/doc/refman/5.0/en/enum.html I agree. When we first created the table, using sets and enums sounded like nice features. But the more I work with them the more I'm running up to their limitations. [1] http://dev.mysql.com/doc/refman/5.0/en/set.html Regards, - Robert http://www.cwelug.org/downloads Help others get OpenSource software. Distribute FLOSS for Windows, Linux, *BSD, and MacOS X with BitTorrent _______________________________________________ CWE-LUG mailing list [email protected] http://www.cwelug.org/ http://www.cwelug.org/archives/ http://www.cwelug.org/mailinglist/
