<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="replication-features-charset">
      </a>
      19.5.1.3 Replication and Character Sets
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045135949280">
  </a>
  <a class="indexterm" name="idm46045135947792">
  </a>
  <p>
   The following applies to replication between MySQL servers that
        use different character sets:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      If the source has databases with a character set different
            from the global
      <a class="link" href="server-system-variables.html#sysvar_character_set_server">
       <code class="literal">
        character_set_server
       </code>
      </a>
      value,
            you should design your
      <a class="link" href="create-table.html" title="15.1.20 CREATE TABLE Statement">
       <code class="literal">
        CREATE
            TABLE
       </code>
      </a>
      statements so that they do not implicitly
            rely on the database default character set. A good
            workaround is to state the character set and collation
            explicitly in
      <a class="link" href="create-table.html" title="15.1.20 CREATE TABLE Statement">
       <code class="literal">
        CREATE TABLE
       </code>
      </a>
      statements.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
