[thelist] boolean in MySQL

Michael Mell mike at nthwave.net
Wed Jun 19 16:21:03 CDT 2002


MySQL doesn't have a boolean type, right? So what is the preferred way
to create a column to hold a true/false value?
I've been using
    CHAR(1) DEFAULT "N",
how's that?

Is there some value that PHP would intrinsically recognize as true/false
after a select, like 1 and 0?

thx
--
mike[at]nthwave.net
llemekim         YahooIM
415.455.8812     voice
419.735.1167     fax





More information about the thelist mailing list