<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-collations-table">
      </a>
      28.3.6 The INFORMATION_SCHEMA COLLATIONS Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045080297392">
  </a>
  <p>
   The
   <a class="link" href="information-schema-collations-table.html" title="28.3.6 The INFORMATION_SCHEMA COLLATIONS Table">
    <code class="literal">
     COLLATIONS
    </code>
   </a>
   table provides
      information about collations for each character set.
  </p>
  <p>
   The
   <a class="link" href="information-schema-collations-table.html" title="28.3.6 The INFORMATION_SCHEMA COLLATIONS Table">
    <code class="literal">
     COLLATIONS
    </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">
       COLLATION_NAME
      </code>
     </p>
     <p>
      The collation name.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       CHARACTER_SET_NAME
      </code>
     </p>
     <p>
      The name of the character set with which the collation is
          associated.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       ID
      </code>
     </p>
     <p>
      The collation ID.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       IS_DEFAULT
      </code>
     </p>
     <p>
      Whether the collation is the default for its character set.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       IS_COMPILED
      </code>
     </p>
     <p>
      Whether the character set is compiled into the server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       SORTLEN
      </code>
     </p>
     <p>
      This is related to the amount of memory required to sort
          strings expressed in the character set.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PAD_ATTRIBUTE
      </code>
     </p>
     <p>
      The collation pad attribute, either
      <code class="literal">
       NO PAD
      </code>
      or
      <code class="literal">
       PAD SPACE
      </code>
      . This attribute affects
          whether trailing spaces are significant in string comparisons;
          see
      <a class="xref" href="charset-binary-collations.html#charset-binary-collations-trailing-space-comparisons" title="Trailing Space Handling in Comparisons">
       Trailing Space Handling in Comparisons
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
  <h4>
   <a name="idm46045080276256">
   </a>
   Notes
  </h4>
  <p>
   Collation information is also available from the
   <a class="link" href="show-collation.html" title="15.7.7.5 SHOW COLLATION Statement">
    <code class="literal">
     SHOW COLLATION
    </code>
   </a>
   statement. See
   <a class="xref" href="show-collation.html" title="15.7.7.5 SHOW COLLATION Statement">
    Section 15.7.7.5, “SHOW COLLATION Statement”
   </a>
   . The following statements are
      equivalent:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa27068135"><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> COLLATION_NAME <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>COLLATIONS
  <span class="token punctuation">[</span><span class="token keyword">WHERE</span> COLLATION_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">COLLATION</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>
