MySQL Lists are EOL. Please join:

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

selecting the ENUM valuesChris Cochella22 Mar
  • Re: selecting the ENUM valuesThimble Smith22 Mar
  • Appending to a SET()Daevid Vincent22 Mar
    • Re: Appending to a SET()Paul DuBois22 Mar
  • Binary type? True/False, Yes/No, On/OffDaevid Vincent23 Mar
    • Re: Binary type? True/False, Yes/No, On/OffMicheal Mc Evoy23 Mar