Is there a datatype boolean?, if not ...

[toptomato]

Hi,
I'd like a column to have a value of either true or false but i'm thinking there is no such thing, no such data type (....and why not?!)

if there isn't what's a good alternative?, tiny int?, or i'll just use text reading true or false,

[jedaisoul]

Read the manual.

[aj_nsc]

Read the manual.

This question is in regard to SQL, not PHP - I don't know why you posted a link to the PHP manual.

Fortunately, there is a boolean data type in MySQL, it's a numeric data type. Basically a non zero value is true and 0 is false. Check the MySQL documentation: http://dev.mysql.com/doc/refman/5.5/...-overview.html

[toptomato]

Perfect, thank you