>>>> 2013/05/22 21:17 +0000, Rick James >>>> In query syntax, TRUE is the same as 1; FALSE is the same as 0. <<<<<<<< and UNKNOWN is NULL. (I actually have used a three-state comparison.)
It has been suggested that one who wants a real two-state field use the type CHAR(0) NULL. >>>>>>>> If you have more 'flags', consider the SET datatype. (Yeah, it is somewhat clumsy.) <<<<<<<< And SET is mapped onto some integer, even as ENUM is. BIT, now deprecated I understand, would have been the perfect type to map ENUM onto. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql