Re: mysql data types On Fri, 16 Feb 2007 20:13:39 +0100, Bob Imperial <bimperial@gmail.com>
wrote:
> have a newb question here.... ;-) I am familiar with ms sql and access
> and I'm wonder which data type in mysql is equivalent to ms sql bit
> or ms access "yes/no"? From what I've read, this would be tinyint?
> TIA
From the manual:
BOOL, BOOLEAN
These types are synonyms for TINYINT(1). A value of zero is considered
false. Non-zero values are considered true.
In the future, full boolean type handling will be introduced in accordance
with standard SQL.
--
Rik Wasmus |