<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="charset-compatibility">
      </a>
      12.3.10 Compatibility with Other DBMSs
     </h3>
    </div>
   </div>
  </div>
  <p>
   For MaxDB compatibility these two statements are the same:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa73700236"><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">CREATE</span> <span class="token keyword">TABLE</span> t1 <span class="token punctuation">(</span>f1 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><em class="replaceable">N</em><span class="token punctuation">)</span> <span class="token keyword">UNICODE</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> t1 <span class="token punctuation">(</span>f1 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><em class="replaceable">N</em><span class="token punctuation">)</span> <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span> ucs2<span class="token punctuation">)</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   Both the
   <code class="literal">
    UNICODE
   </code>
   attribute and the
   <code class="literal">
    ucs2
   </code>
   character set are deprecated; you should
        expect them to be removed in a future version of MySQL.
  </p>
 </div>
 <br/>
</div>
