title: Getting MySQL to display the encoding used for a particular column
body: <p>The MySQL manual (http://dev.mysql.com/doc/refman/5.1/en/charset-syntax.html) says:</p>
  
  <blockquote>
    <p>There are default settings for character sets and collations at four levels: server, database, table, and column. The description in the following sections may appear complex, but it has been found in practice that multiple-level defaulting leads to natural and obvious results.</p>
  </blockquote>
  
  <p>I'd like to interrogate a specific CHAR/VARCHAR/TEXT column and find out what encoding MySQL thinks it is. Is there an easy way to do this? I know I can use <code>SHOW CREATE TABLE &lt;table&gt;</code> to see the default charset for the table, but I'd like to do the same thing on the column level, as the docs suggest that it might not be the same as the table default.</p>