View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 09:10 AM
Rik
 
Posts: n/a
Default 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
Reply With Quote