[thelist] boolean in MySQL

Michael Mell mike at nthwave.net
Wed Jun 19 16:58:01 CDT 2002


Howard Cheng wrote:

> MySQL itself uses the ENUM datatype with values of 'Y' and 'N'. If you look
> in the user tables, you'll see the proof.

and so I see, good call.

However, PHP will recognize 0 and '0' as false:
http://www.php.net/manual/en/language.types.boolean.php

I think I'll use ENUM (0, 1) from now on.

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





More information about the thelist mailing list