title: MySQL enums empty value
body: <p>I am trying to understand how enums could be used in mysql. 
  If I insert anything to enum field that is out of the enum type -- mysql inserts empty string (with value 0).</p>
  
  <ul>
  <li>fruit ENUM ('APPLE','BANANA','PEACH');</li>
  <li>INSERT ... fruit='BANNANA'</li>
  </ul>
  
  <p>Simple misspelling and MySQL inserts empty value, breaks database integrity and makes enums extremely useless.</p>
  
  <p>CHECK constraints could help here but MySQL does not support them (pretty funny for "most popular" database in 2011)</p>
  
  <p>The only way I see is to write the trigger to prevent empty string but it is too much work to write trigger for such a simple case.</p>
  
  <p>Does there is a way to disable "empty string" MySQL behavior for enums?</p>
  
  <p>Thanks</p>