An enum should work fine as you've described, but remember that the ENUM type is a MySQL proprietary type and if you ever want to convert to another database (Oracle, PostgreSQL, MSSQL, Etc.), you may have to find an appropiate solution (i.e. convert to integer and use 0 and 1)...
On Tue, 2 Oct 2001, Jordan Elver wrote: > I've decided on enum. Should work fine. I've used it before and it works fine > with PHP. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php