title: What mysql data type for radio buttons?
body: <p>I'm making a form with radio buttons  (see <a href="http://jsfiddle.net/mjmitche/3c6Mc/" rel="nofollow">http://jsfiddle.net/mjmitche/3c6Mc/</a>) and users are submitting data mostly through radio buttons. What "type" will the values for the radio buttons have to be/should they be in the mysql table?  </p>
  
  <p>The fields advocacy, drafting, interview etc will all be either "pass" or "fail" on the webform, so what do I do in the database?</p>
  
  <pre><code>CREATE TABLE `shoutbox`(  
      `id` int(5) NOT NULL auto_increment,  
      `date` timestamp NOT NULL default CURRENT_TIMESTAMP,  
      `instructor` varchar(25) NOT NULL ,  
      `secretmessage` varchar(255) NOT NULL default '', 
      `advocacy`     NOT NULL, 
      `drafting`     NOT NULL, 
      `interview`
      `letter`
      `solicitor`
      `barrister`
      PRIMARY KEY (`id`)  
  );
  </code></pre>
  
  <p><strong>Boolean</strong></p>
  
  <p>If I use a Boolean, do I set the values for Pass and Fail to 1 and 0? </p>
  
  <pre><code>    &lt;tr&gt;  
  
          &lt;td&gt;&lt;label&gt;Interview&lt;/label&gt;&lt;/td&gt;  
          &lt;td&gt;&lt;input type="radio" name="interview" value="1" /&gt; Pass&lt;/td&gt;
          &lt;td&gt;&lt;input type="radio" name="interview" value="0" /&gt; Fail&lt;/td&gt;  
      &lt;/tr&gt;
  </code></pre>
  
  <p>with this mysql? </p>
  
  <pre><code>    CREATE TABLE `shoutbox`(  
     `interview` BOOLEAN NOT NULL, 
  </code></pre>
  
  <p><strong>TinyINT</strong></p>
  
  <p>If I use a TinyInt, do I also set the value of Pass and Fail to 1 and 0? </p>
  
  <pre><code>             &lt;tr&gt;  
  
                  &lt;td&gt;&lt;label&gt;Interview&lt;/label&gt;&lt;/td&gt;  
                  &lt;td&gt;&lt;input type="radio" name="interview" value="1" /&gt; Pass&lt;/td&gt;
                  &lt;td&gt;&lt;input type="radio" name="interview" value="0" /&gt; Fail&lt;/td&gt;  
              &lt;/tr&gt;
  
  
      CREATE TABLE `shoutbox`(  
     `interview` TINYINT NOT NULL, 
  </code></pre>
  
  <p><strong>ENUM</strong></p>
  
  <p>If I use enum, do I set the value to "pass" and "fail" and then use the same names in the database with enum? </p>
  
  <p>  </p>
  
  <pre><code> &lt;td&gt;&lt;label&gt;Interview&lt;/label&gt;&lt;/td&gt;  
    &lt;td&gt;&lt;input type="radio" name="interview" value="pass" /&gt; Pass&lt;/td&gt;
   &lt;td&gt;&lt;input type="radio" name="interview" value="fail" /&gt; Fail&lt;/td&gt;  
  &lt;/tr&gt;
  </code></pre>
  
  <p>Mysql</p>
  
  <pre><code>            CREATE TABLE `shoutbox`(  
             `interview` enum('pass', 'fail') NOT NULL, 
  </code></pre>