List:General Discussion« Previous MessageNext Message »
From:Michael Collins Date:January 25 2002 5:13pm
Subject:Re: MySQL Checkbox table field
View as plain text  
At 10:49 AM -0600 1/25/02, Dan Nelson wrote:
>  > >Which field type do I use for a simply checkbox Y,N?

>The BIT type seems to be the best fit.  It's currently a synonym for
>CHAR(1), but there's a TODO item:
>
>    * Optimise `BIT' type to take 1 bit (now `BIT' takes 1 char).

Are you thinking MS SQL Server? I am not sure there is a bit type in 
MySQL? Do you mean Char(0)? Anyhow, in MS SQL Server a bit type 
column cannot be indexed so you are better off with CHAR(1).

-- 
Michael
__
||| Michael Collins       |||
||| Kuwago Web Services   |||      mailto:mcollins@stripped
||| Seattle, WA, USA      |||      http://www.lassodev.com
Thread
Re: MySQL Checkbox table fieldVernon A Webb25 Jan
Re: MySQL Checkbox table fieldMichael Collins25 Jan
  • Re: MySQL Checkbox table fieldDan Nelson25 Jan
    • Re: MySQL Checkbox table fieldMichael Collins25 Jan
      • Re: MySQL Checkbox table fieldDan Nelson25 Jan
        • Re: MySQL Checkbox table fieldMichael Collins25 Jan
          • Re: MySQL Checkbox table fieldDan Nelson25 Jan
            • Re: MySQL Checkbox table fieldMichael Collins25 Jan
RE: MySQL Checkbox table fieldTodd Williamsen25 Jan
RE: MySQL Checkbox table fieldJames E. Hicks III25 Jan
RE: MySQL Checkbox table fieldMatthew Walker25 Jan
  • RE: MySQL Checkbox table fieldPaul DuBois25 Jan
Re: MySQL Checkbox table fieldDavid Shields25 Jan
RE: MySQL Checkbox table fieldMatthew Walker25 Jan
  • RE: MySQL Checkbox table fieldPaul DuBois25 Jan