title: enum or char(1) in MySQL
body: <p>Sometimes I am not sure whether using enum or char(1) in MysQL. For instance, I store statuses of posts. Normally, I only need <strong><code>Active</code></strong> or <strong><code>Passive</code></strong> values in <code>status</code> field. I have two options:</p>
  
  <pre><code>// CHAR
  status char(1);
  
  // ENUM (but too limited)
  status enum('A', 'P');
  </code></pre>
  
  <p>What about if I want to add one more status type (ie. <code>Hidden</code>) in the future? If I have small data, it won't be an issue. But if i have too large data, so editing ENUM type will be problem, i think.</p>
  
  <p>So what's your advice if we also think about MySQL performance? Which way I would go?</p>