<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="charset-collation-compatibility">
      </a>
      12.8.3 Character Set and Collation Compatibility
     </h3>
    </div>
   </div>
  </div>
  <p>
   Each character set has one or more collations, but each
        collation is associated with one and only one character set.
        Therefore, the following statement causes an error message
        because the
   <code class="literal">
    latin2_bin
   </code>
   collation is not legal
        with the
   <code class="literal">
    latin1
   </code>
   character set:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa24755424"><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">SELECT</span> _latin1 <span class="token string">'x'</span> <span class="token keyword">COLLATE</span> latin2_bin<span class="token punctuation">;</span>
<span class="token output">ERROR 1253 (42000)<span class="token punctuation">:</span> COLLATION 'latin2_bin' is not valid
for CHARACTER SET 'latin1'</span></code></pre>
  </div>
 </div>
 <br/>
</div>
