<p>This statement:</p>
<p><code>sqlt-graph -f MySQL -o fail.png -t png fail.sql</code></p>
<p>produces the following error:</p>
<pre><code>       ERROR (line 3): Invalid statement: Was expecting comment, or use, or
                       set, or drop, or create, or alter, or insert, or
                       delimiter, or empty statement
Error: translate: Error with parser 'SQL::Translator::Parser::MySQL':  no results at ~/perl5/perlbrew/perls/perl-5.22.4/bin/sqlt-graph line 195.
</code></pre>
<p>The following SQL was used to produce the error:</p>
<div class="highlight highlight-source-sql"><pre><span class="pl-k">SET</span> NAMES <span class="pl-s"><span class="pl-pds">'</span>utf8<span class="pl-pds">'</span></span>;
<span class="pl-k">CREATE</span> <span class="pl-k">DATABASE</span> <span class="pl-en">example</span> CHARACTER <span class="pl-k">SET</span> utf8mb4 COLLATE utf8mb4_unicode_ci;
USE example;

<span class="pl-k">CREATE</span> <span class="pl-k">TABLE</span> <span class="pl-en">articel</span> (
    id <span class="pl-k">INTEGER</span> <span class="pl-k">NOT NULL</span> AUTO_INCREMENT,
    name <span class="pl-k">VARCHAR</span>(<span class="pl-c1">255</span>) <span class="pl-k">NOT NULL</span>
) CHARACTER <span class="pl-k">SET</span> utf8mb4 COLLATE utf8mb4_unicode_ci;</pre></div>
<p>When I remove <code>CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci</code> from the <strong>create statement</strong>, it parses just fine.</p>
<p>Note: The character set for the table does not produce an error.</p>
<p>According to <a href="https://dev.mysql.com/doc/refman/5.7/en/charset-database.html" rel="nofollow">https://dev.mysql.com/doc/refman/5.7/en/charset-database.html</a> the used syntax for a character set in <code>create</code> should be valid.</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/dbsrgits/sql-translator/issues/101">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AASeAmfSjoESAo40Y4-il0wsw-9awNP2ks5tbRF2gaJpZM4ScCae">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AASeAsmeCu4r_7UzLAjUb5_zqAaRwt1_ks5tbRF2gaJpZM4ScCae.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
  <link itemprop="url" href="https://github.com/dbsrgits/sql-translator/issues/101"></link>
  <meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>

<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/dbsrgits/sql-translator","title":"dbsrgits/sql-translator","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/dbsrgits/sql-translator"}},"updates":{"snippets":[{"icon":"DESCRIPTION","message":"`SQL::Translator::Parser::MySQL` doesn't accept `character set` in `create` (#101)"}],"action":{"name":"View Issue","url":"https://github.com/dbsrgits/sql-translator/issues/101"}}}</script>