title: MySQL fixed-length and variable-length data types
body: <p>I am optimizing DB and there is something which is not clear to me about fixed-length data types. </p>
  
  <p>As far as I know these data types are <strong>fixed-length</strong>:</p>
  
  <ul>
  <li>CHAR(n)</li>
  <li>DATE</li>
  <li>TIME</li>
  <li>DATETIME</li>
  <li>TINYINT</li>
  <li>SMALLINT</li>
  <li>MEDIUMINT</li>
  <li>INT</li>
  <li>FLOAT</li>
  <li>DOUBLE</li>
  </ul>
  
  <p>And these are <strong>variable-length</strong>:</p>
  
  <ul>
  <li>TEXT</li>
  <li>VARCHAR</li>
  <li>BLOB</li>
  </ul>
  
  <p><strong>Please correct me if I am wrong!</strong> </p>
  
  <p>Now, my question is: <strong>Are these data types fixed-length or variable-length?</strong></p>
  
  <ul>
  <li><strong>TIMESTAMP</strong></li>
  <li><strong>ENUM</strong></li>
  </ul>
  
  <p>Thanks.</p>