<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-collation-character-set-applicability-table">
      </a>
      28.3.7 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045080270048">
  </a>
  <p>
   The
   <a class="link" href="information-schema-collation-character-set-applicability-table.html" title="28.3.7 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table">
    <code class="literal">
     COLLATION_CHARACTER_SET_APPLICABILITY
    </code>
   </a>
   table indicates what character set is applicable for what
      collation.
  </p>
  <p>
   The
   <a class="link" href="information-schema-collation-character-set-applicability-table.html" title="28.3.7 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table">
    <code class="literal">
     COLLATION_CHARACTER_SET_APPLICABILITY
    </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>
   </ul>
  </div>
  <h4>
   <a name="idm46045080260624">
   </a>
   Notes
  </h4>
  <p>
   The
   <a class="link" href="information-schema-collation-character-set-applicability-table.html" title="28.3.7 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table">
    <code class="literal">
     COLLATION_CHARACTER_SET_APPLICABILITY
    </code>
   </a>
   columns are equivalent to the first two columns displayed by the
   <a class="link" href="show-collation.html" title="15.7.7.5 SHOW COLLATION Statement">
    <code class="literal">
     SHOW COLLATION
    </code>
   </a>
   statement.
  </p>
 </div>
 <br/>
</div>
