<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-character-sets-table">
      </a>
      28.3.4 The INFORMATION_SCHEMA CHARACTER_SETS Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045080333712">
  </a>
  <p>
   The
   <a class="link" href="information-schema-character-sets-table.html" title="28.3.4 The INFORMATION_SCHEMA CHARACTER_SETS Table">
    <code class="literal">
     CHARACTER_SETS
    </code>
   </a>
   table provides
      information about available character sets.
  </p>
  <p>
   The
   <a class="link" href="information-schema-character-sets-table.html" title="28.3.4 The INFORMATION_SCHEMA CHARACTER_SETS Table">
    <code class="literal">
     CHARACTER_SETS
    </code>
   </a>
   table has these
      columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       CHARACTER_SET_NAME
      </code>
     </p>
     <p>
      The character set name.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       DEFAULT_COLLATE_NAME
      </code>
     </p>
     <p>
      The default collation for the character set.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       DESCRIPTION
      </code>
     </p>
     <p>
      A description of the character set.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       MAXLEN
      </code>
     </p>
     <p>
      The maximum number of bytes required to store one character.
     </p>
    </li>
   </ul>
  </div>
  <h4>
   <a name="idm46045080320784">
   </a>
   Notes
  </h4>
  <p>
   Character set information is also available from the
   <a class="link" href="show-character-set.html" title="15.7.7.4 SHOW CHARACTER SET Statement">
    <code class="literal">
     SHOW CHARACTER SET
    </code>
   </a>
   statement. See
   <a class="xref" href="show-character-set.html" title="15.7.7.4 SHOW CHARACTER SET Statement">
    Section 15.7.7.4, “SHOW CHARACTER SET Statement”
   </a>
   . The following statements are
      equivalent:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa93165941"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token keyword">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>CHARACTER_SETS
  <span class="token punctuation">[</span><span class="token keyword">WHERE</span> CHARACTER_SET_NAME <span class="token operator">LIKE</span> <span class="token string">'<em class="replaceable">wild</em>'</span><span class="token punctuation">]</span>

<span class="token keyword">SHOW</span> <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span>
  <span class="token punctuation">[</span><span class="token operator">LIKE</span> <span class="token string">'<em class="replaceable">wild</em>'</span><span class="token punctuation">]</span></code></pre>
  </div>
 </div>
 <br/>
</div>
