after boolean becomes tinyint(1)

[yang]

hello everyone,
question is: when i create a boolean type column into mysql table, then it will auto change to tinyint(1),

also, in my php function, if $check = true; then the condition ($check == tinyint(1)variable) is valid, but if $check = false, then the condition ($check == tinyint(1)variable) is Invalid!!, but if $check = 0, it wll become valid.

why? and any better suggestion for improve when i facing this situation??~

regards

[MeroD]

BOOLEAN is an alias to TINYINT(1)

Zero is false, anything else is true. Your function will return 0 or 1, which will get transformed into a string--so in PHP you have the strings '0' and '1'... If you need to compare with a zero use ===

[seandisanti]

you can also use bit for boolean values. it's mostly a matter of preference, but if you have multiple boolean fields, they are stored in a single byte (up to 8 of them) rather than requiring a byte each as with tinyint.