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 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. hope that helps. cheers, noel On Tuesday, October 30, 2001 1:52 PM, 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 > > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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
