title: How to check if MySQL table is UTF-8 and has storageEngine InnoDB?
body: <p>Googling around just finds instructions for changing from one format to another, but I can't seem to find how exactly to make sure which of these I have first.</p>
  
  <p>How can I:</p>
  
  <ol>
  <li>Check what character encoding a table has?</li>
  <li>Check what storage engine a table uses?</li>
  <li>Check if all tables are certain encoding?</li>
  <li>Check if all tables have a certain storage engine?</li>
  </ol>