is mysql support boolean ?

[Anon]

Hi, How can I create a table with a boolean in mysql?

[brandonschnell]

1) last time i checked, columns of type boolean aren't supported by mysql. the crash-me page seems to support that. http://www.mysql.com/information/crash-me.php

2) use another column type and fake boolean support. use something like a TINYINT and assume 0 is FALSE and 1 is TRUE.

[Anon]

Hi,

Here is another solution (I found)
create table program (
name varchar(100) NOT NULL PRIMARY KEY,
length varchar(20) NOT NULL,
whatgrades varchar(20) NOT NULL,
contact varchar(100) NOT NULL,
answer ENUM('true','false') NOT NULL,
extension varchar(20) NOT NULL
);

I want to create a user interface for the admin to insert the above fields in the program table, they are all text fields except the field "answer" that should be a check or radio button, could you please show me how to do it for the answer field ?

Thanks