<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="charset-mysql">
      </a>
      12.2 Character Sets and Collations in MySQL
     </h2>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="charset-repertoire.html">
       12.2.1 Character Set Repertoire
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="charset-metadata.html">
       12.2.2 UTF-8 for Metadata
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <p>
   MySQL Server supports multiple character sets, including several
      Unicode character sets. To display the available character sets,
      use the
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   <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 or 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. A
      partial listing follows. For more complete information, see
   <a class="xref" href="charset-charsets.html" title="12.10 Supported Character Sets and Collations">
    Section 12.10, “Supported Character Sets and Collations”
   </a>
   .
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa2101057"><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 prompt">mysql&gt;</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 output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Charset  <span class="token punctuation">|</span> Description                     <span class="token punctuation">|</span> Default collation   <span class="token punctuation">|</span> Maxlen <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> big5     <span class="token punctuation">|</span> Big5 Traditional Chinese        <span class="token punctuation">|</span> big5_chinese_ci     <span class="token punctuation">|</span>      2 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> binary   <span class="token punctuation">|</span> Binary pseudo charset           <span class="token punctuation">|</span> binary              <span class="token punctuation">|</span>      1 <span class="token punctuation">|</span></span>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token output"><span class="token punctuation">|</span> latin1   <span class="token punctuation">|</span> cp1252 West European            <span class="token punctuation">|</span> latin1_swedish_ci   <span class="token punctuation">|</span>      1 <span class="token punctuation">|</span></span>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token output"><span class="token punctuation">|</span> ucs2     <span class="token punctuation">|</span> UCS<span class="token punctuation">-</span>2 Unicode                   <span class="token punctuation">|</span> ucs2_general_ci     <span class="token punctuation">|</span>      2 <span class="token punctuation">|</span></span>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token output"><span class="token punctuation">|</span> utf8mb3  <span class="token punctuation">|</span> UTF<span class="token punctuation">-</span>8 Unicode                   <span class="token punctuation">|</span> utf8mb3_general_ci  <span class="token punctuation">|</span>      3 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4  <span class="token punctuation">|</span> UTF<span class="token punctuation">-</span>8 Unicode                   <span class="token punctuation">|</span> utf8mb4_0900_ai_ci  <span class="token punctuation">|</span>      4 <span class="token punctuation">|</span></span>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span></code></pre>
  </div>
  <p>
   By default, 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 displays all available character sets. It takes an
      optional
   <a class="link" href="string-comparison-functions.html#operator_like">
    <code class="literal">
     LIKE
    </code>
   </a>
   or
   <code class="literal">
    WHERE
   </code>
   clause that indicates which character set
      names to match. The following example shows some of the Unicode
      character sets (those based on Unicode Transformation Format):
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa25021910"><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 prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span> <span class="token operator">LIKE</span> <span class="token string">'utf%'</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Charset <span class="token punctuation">|</span> Description      <span class="token punctuation">|</span> Default collation  <span class="token punctuation">|</span> Maxlen <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> utf16   <span class="token punctuation">|</span> UTF<span class="token punctuation">-</span>16 Unicode   <span class="token punctuation">|</span> utf16_general_ci   <span class="token punctuation">|</span>      4 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf16le <span class="token punctuation">|</span> UTF<span class="token punctuation">-</span>16LE Unicode <span class="token punctuation">|</span> utf16le_general_ci <span class="token punctuation">|</span>      4 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf32   <span class="token punctuation">|</span> UTF<span class="token punctuation">-</span>32 Unicode   <span class="token punctuation">|</span> utf32_general_ci   <span class="token punctuation">|</span>      4 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb3 <span class="token punctuation">|</span> UTF<span class="token punctuation">-</span>8 Unicode    <span class="token punctuation">|</span> utf8mb3_general_ci <span class="token punctuation">|</span>      3 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> UTF<span class="token punctuation">-</span>8 Unicode    <span class="token punctuation">|</span> utf8mb4_0900_ai_ci <span class="token punctuation">|</span>      4 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span></code></pre>
  </div>
  <p>
   A given character set always has at least one collation, and most
      character sets have several. To list the display collations for a
      character set, use the
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   <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 or 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>
  <p>
   By default, the
   <a class="link" href="show-collation.html" title="15.7.7.5 SHOW COLLATION Statement">
    <code class="literal">
     SHOW COLLATION
    </code>
   </a>
   statement displays all available collations. It takes an optional
   <a class="link" href="string-comparison-functions.html#operator_like">
    <code class="literal">
     LIKE
    </code>
   </a>
   or
   <code class="literal">
    WHERE
   </code>
   clause that indicates which collation names to display. For
      example, to see the collations for the default character set,
   <code class="literal">
    utf8mb4
   </code>
   , use this statement:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa77833063"><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 prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">COLLATION</span> <span class="token keyword">WHERE</span> <span class="token keyword">Charset</span> <span class="token operator">=</span> <span class="token string">'utf8mb4'</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Collation                  <span class="token punctuation">|</span> Charset <span class="token punctuation">|</span> Id  <span class="token punctuation">|</span> Default <span class="token punctuation">|</span> Compiled <span class="token punctuation">|</span> Sortlen <span class="token punctuation">|</span> Pad_attribute <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_0900_ai_ci         <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 255 <span class="token punctuation">|</span> Yes     <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_0900_as_ci         <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 305 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_0900_as_cs         <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 278 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_0900_bin           <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 309 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       1 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_bin                <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span>  46 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       1 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_croatian_ci        <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 245 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_cs_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 266 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_cs_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 289 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_czech_ci           <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 234 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_danish_ci          <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 235 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_da_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 267 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_da_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 290 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_de_pb_0900_ai_ci   <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 256 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_de_pb_0900_as_cs   <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 279 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_eo_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 273 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_eo_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 296 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_esperanto_ci       <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 241 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_estonian_ci        <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 230 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_es_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 263 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_es_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 286 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_es_trad_0900_ai_ci <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 270 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_es_trad_0900_as_cs <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 293 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_et_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 262 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_et_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 285 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_general_ci         <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span>  45 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       1 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_german2_ci         <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 244 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_hr_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 275 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_hr_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 298 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_hungarian_ci       <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 242 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_hu_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 274 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_hu_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 297 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_icelandic_ci       <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 225 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_is_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 257 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_is_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 280 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_ja_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 303 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_ja_0900_as_cs_ks   <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 304 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>      24 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_latvian_ci         <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 226 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_la_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 271 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_la_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 294 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_lithuanian_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 236 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_lt_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 268 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_lt_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 291 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_lv_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 258 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_lv_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 281 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_persian_ci         <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 240 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_pl_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 261 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_pl_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 284 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_polish_ci          <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 229 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_romanian_ci        <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 227 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_roman_ci           <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 239 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_ro_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 259 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_ro_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 282 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_ru_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 306 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_ru_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 307 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_sinhala_ci         <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 243 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_sk_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 269 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_sk_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 292 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_slovak_ci          <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 237 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_slovenian_ci       <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 228 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_sl_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 260 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_sl_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 283 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_spanish2_ci        <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 238 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_spanish_ci         <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 231 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_sv_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 264 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_sv_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 287 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_swedish_ci         <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 232 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_tr_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 265 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_tr_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 288 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_turkish_ci         <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 233 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_unicode_520_ci     <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 246 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_unicode_ci         <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 224 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_vietnamese_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 247 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> PAD SPACE     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_vi_0900_ai_ci      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 277 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_vi_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 300 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4_zh_0900_as_cs      <span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> 308 <span class="token punctuation">|</span>         <span class="token punctuation">|</span> Yes      <span class="token punctuation">|</span>       0 <span class="token punctuation">|</span> NO PAD        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span></code></pre>
  </div>
  <p>
   For more information about those collations, see
   <a class="xref" href="charset-unicode-sets.html" title="12.10.1 Unicode Character Sets">
    Section 12.10.1, “Unicode Character Sets”
   </a>
   .
  </p>
  <p>
   Collations have these general characteristics:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Two different character sets cannot have the same collation.
     </p>
    </li>
    <li class="listitem">
     <p>
      Each character set has a
      <span class="emphasis">
       <em>
        default
          collation
       </em>
      </span>
      . For example, the default collations for
      <code class="literal">
       utf8mb4
      </code>
      and
      <code class="literal">
       latin1
      </code>
      are
      <code class="literal">
       utf8mb4_0900_ai_ci
      </code>
      and
      <code class="literal">
       latin1_swedish_ci
      </code>
      , respectively. The
      <code class="literal">
       INFORMATION_SCHEMA
      </code>
      <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 and 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
          indicate the default collation for each character set. The
      <code class="literal">
       INFORMATION_SCHEMA
      </code>
      <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 and the
      <a class="link" href="show-collation.html" title="15.7.7.5 SHOW COLLATION Statement">
       <code class="literal">
        SHOW COLLATION
       </code>
      </a>
      statement have a
          column that indicates for each collation whether it is the
          default for its character set (
      <code class="literal">
       Yes
      </code>
      if so,
          empty if not).
     </p>
    </li>
    <li class="listitem">
     <p>
      Collation names start with the name of the character set with
          which they are associated, generally followed by one or more
          suffixes indicating other collation characteristics. For
          additional information about naming conventions, see
      <a class="xref" href="charset-collation-names.html" title="12.3.1 Collation Naming Conventions">
       Section 12.3.1, “Collation Naming Conventions”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   When a character set has multiple collations, it might not be
      clear which collation is most suitable for a given application. To
      avoid choosing an inappropriate collation, perform some
      comparisons with representative data values to make sure that a
      given collation sorts values the way you expect.
  </p>
 </div>
 <br/>
</div>
