Like you, I too consider anything not 0 as true.
The cool thing about enum types is you can do it both ways (if you are simulating a
boolean). This flexibility it affords the best of both worlds.
It gives coders the ability to deal in binary AND/OR something more english like -
which in the long run can make for more readable, maintainable code.
Jon Haworth <[EMAIL PROTECTED]> wrote:
>
> You certainly could, in fact you should use whatever you're happy with.
> Intuitive coding for me personally would have "anything that isn't 0" as
> true and "0" as false, if you prefer Y and N then here's a perfect solution.
>
> Cheers
> Jon
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 02 March 2001 14:32
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: RE: yes/no
>
>
> Why not use an enumerated type. It takes up almost no storage and it makes
> for more intuitive coding since you can assign Y/N to 1/0.
>
> Jon Haworth <[EMAIL PROTECTED]> wrote:
> >
> > I usually use a tinyint with a value of 1 for true, and 0 for false. There
> > doesn't appear to be a boolean datatype in MySQL, but I may have missed it
> > :-)
> >
> >
> > HTH
> > Jon
> >
> >
> > -----Original Message-----
> > From: Scott Dunn [mailto:[EMAIL PROTECTED]]
> > Sent: 02 March 2001 13:55
> > To: Mysql
> > Subject: yes/no
> >
> >
> > I want to have like in Access a column that is yes or no or true or false,
> > something on that line. I looked at www.mysql.com but could not find
> > anything. I don't know what exactly I am looking for. Could someone give
> me
> > a hand it will be greatly appreciated.
> >
> >
> > ---------------------------------------------------------------------
> > 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
> >
> >
> >
> > **********************************************************************
> > 'The information included in this Email is of a confidential nature and is
>
> > intended only for the addressee. If you are not the intended addressee,
> > any disclosure, copying or distribution by you is prohibited and may be
> > unlawful. Disclosure to any party other than the addressee, whether
> > inadvertent or otherwise is not intended to waive privilege or
> > confidentiality'
> >
> > **********************************************************************
> >
> > ---------------------------------------------------------------------
> > 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
> >
> >
> --
> ===========================================================================
> "If you put three drops of poison into a 100 percent pure Java, you get -
> Windows. If you put a few drops of Java into Windows, you still have
> Windows."
> -- Sun Microsystems CEO, Scott McNealy
>
> __________________________________________________________________
> Get your own FREE, personal Netscape Webmail account today at
> http://webmail.netscape.com/
>
--
===========================================================================
"If you put three drops of poison into a 100 percent pure Java, you get - Windows. If
you put a few drops of Java into Windows, you still have Windows."
-- Sun Microsystems CEO, Scott McNealy
__________________________________________________________________
Get your own FREE, personal Netscape Webmail account today at
http://webmail.netscape.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
