> SET and ENUM in mysql are super dangerous. > They promote really bad design patterns and lock people > into MySQL > specific schema that is a "Complete Fucking Nightmare" to port to > another DB system. If people did a standard normalized schema, no > issues would occur when porting to a better DB.
I use ENUM sometimes. It seemed like a straightforward thing to me (although I think either MySQL or my interface to it seems to have trouble with an enum option of the empty string). Leaving aside portability, what bad design patterns does it promote? ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object