List: | General Discussion | « Previous MessageNext Message » | |
From: | Dan Nelson | Date: | January 25 2002 4:49pm |
Subject: | Re: MySQL Checkbox table field | ||
View as plain text |
In the last episode (Jan 25), Michael Collins said: > At 10:58 AM -0500 1/25/02, Vernon A Webb wrote: > > > database,sql,query,table > > > >Which field type do I use for a simply checkbox Y,N? > > How about CHAR(1)? 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). -- Dan Nelson dnelson@stripped
Thread | ||
---|---|---|
• Re: MySQL Checkbox table field | Vernon A Webb | 25 Jan |
• Re: MySQL Checkbox table field | Michael Collins | 25 Jan |
• Re: MySQL Checkbox table field | Dan Nelson | 25 Jan |
• Re: MySQL Checkbox table field | Michael Collins | 25 Jan |
• Re: MySQL Checkbox table field | Dan Nelson | 25 Jan |
• Re: MySQL Checkbox table field | Michael Collins | 25 Jan |
• Re: MySQL Checkbox table field | Dan Nelson | 25 Jan |
• Re: MySQL Checkbox table field | Michael Collins | 25 Jan |
• RE: MySQL Checkbox table field | Todd Williamsen | 25 Jan |
• RE: MySQL Checkbox table field | James E. Hicks III | 25 Jan |
• RE: MySQL Checkbox table field | Matthew Walker | 25 Jan |
• RE: MySQL Checkbox table field | Paul DuBois | 25 Jan |
• Re: MySQL Checkbox table field | David Shields | 25 Jan |
• RE: MySQL Checkbox table field | Matthew Walker | 25 Jan |
• RE: MySQL Checkbox table field | Paul DuBois | 25 Jan |