MySQL does not have a boolean type. For yes/no or true/false information, I usually use an enumerator (enum) and define the "false" value first and the "true" second. (So "no" would be first and "yes" second.) Then, when I query for the value in that field, I can ask for it minus one, and I get a numerical value that can be translated more easily into a boolean value, where "false" is 0 and "true" is 1. MySQL assigns the value of 1 to the first element of the enumerator and reserves 0 for errors, so that's why you have to subtract. If you simply query for the value of the field, you will get "false," "true," "no," "yes," or whatever -- but, if you put any arithmetic operator into your SQL statement, MySQL will send you the results of calculation using the numerical internal representation instead.
create table boolean_table(boolean enum("false","true")); insert into boolean_table values("true")); <?php $sql = "select boolean - 1 from boolean table"; $r = mysql_query($sql, $link) or die("Cannot get result"); $row = mysql_fetch_assoc($r); if ($row["boolean"]) print "The value is true.\n"; ?> If I am working in C or PHP or another language that treats 0 as false and 1 as true, I can do this sort of test with the results -- or the reverse -- (this example is in C) -- if (!row[0]) puts("The value is false."); Amittai Aviram [EMAIL PROTECTED] ----- Original Message ----- From: "Angelo Carmo" <[EMAIL PROTECTED]> aTo: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 8:36 PM Subject: access2mysql data types > > Hi people, > > what is the best type to substitute the boolean type of msaccess tables. > Or mysql databases support the boolean type? > > Angelo. > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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