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]> wrote: > > You can use a tinyint and say that 0 is false 1 is true, or you could > define an enum or something. There has been much discussion on this list > about which is the best approach - basically depends on what you see as > important, you might want to do a search on old list stuff to get some > ideas. > One of the guys at work suggested char(0) as a boolean. Your two values are '' and IS NULL. ===== dcampbel - duncan campbell __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php