Re: MySQL Checkbox table field

[Michael Collins]

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