I use char(1) with 't' and 'f'. The JDBC-Driver I am using (mm.sql) recognizes this correctly as Boolean.
Peter > -----Original Message----- > From: Jon Haworth [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 15, 2002 5:24 PM > To: 'T.Thiessens'; [EMAIL PROTECTED] > Subject: RE: Boolean! > > > Hi T., > > > How can I set the domain of a attribute to a boolean value? > > OK, I'm not entirely clear with your terminology, but I think you're asking > "how do I define a field as a boolean"... > > MySQL doesn't provide a boolean datatype as such, but in my experience the > best way to handle it is to define a field as a smallint and use 1 for true > and 0 for false. > > Cheers > Jon > > --------------------------------------------------------------------- > 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