Yes/No (Bit) in Mysql?

[elemental]

Hey there! I'm using Coldfusion and Ben Forta's excellent book the Web Application Construction Kit. In it, he has exercises that use Access 2000. So I try to recreate the table structures and data using MySQL 3.23. But there are some fields that have a yes/no value (ex. IsEgoManic Bit(Yes/No). any thoughts?
Thanks Gang!
Erik

 

[swampBoogie]

Mysql does not have a boolean datatype.

You can either use a tinyint using 0 for false and everything else true or use a char(3) using 'Yes'/'No' or ...

Just pick a suitable convetion.