| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Daevid Vincent | Date: | March 22 1999 11:10pm |
| Subject: | Binary type? True/False, Yes/No, On/Off | ||
| View as plain text | |||
Is there a preferred way to make a field in a SQL database that only has two options, such as Yes/no, On/Off, True/False? I have a field that would equate to a checkbox on a web page. Either the person wants to be contacted or they don't. What is the best way to create that field in mySQL? Using a TINYINT? CHAR? ENUM? It seems there should be a field/data type for this kind of "flag" scenario. Daevid Vincent. What is http://TheMatrix.com
| Thread | ||
|---|---|---|
| • selecting the ENUM values | Chris Cochella | 22 Mar |
| • Re: selecting the ENUM values | Thimble Smith | 22 Mar |
| • Appending to a SET() | Daevid Vincent | 22 Mar |
| • Re: Appending to a SET() | Paul DuBois | 22 Mar |
| • Binary type? True/False, Yes/No, On/Off | Daevid Vincent | 23 Mar |
| • Re: Binary type? True/False, Yes/No, On/Off | Micheal Mc Evoy | 23 Mar |