Shomaail [SMTP:[EMAIL PROTECTED]] wrote:
> > I am using MySQL 3.23.22-beta
> > pls tell is there any way to define boolean variable in this db
> > what is the BOOL for ?
> > declaring a var BOOL make it TINYINT(1)! but not boolean
> >
> > thanks
> > Shomaai
--- Noel Clarkson <[EMAIL PROTECTED]> w
Hi there,
My understanding is that there is no BOOL type in MySQL but BOOL is allowed
in create table statements (or alter table etc) for compatibility with
other databases (but MySQL uses a tinyint for a bool because it doesn't
have bool).
You can use a tinyint and say that 0 is false 1 is t