Django illegal mix collations
<p>When django tries to sync db with another external crm it raises the error: </p>

<pre><code>OperationalError(1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='")
</code></pre>

<p>I tried to run </p>

<pre><code>ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE     utf8_general_ci;
</code></pre>

<p>No results. 
Also cnf file was created:</p>

<pre><code>[client]
default-character-set=utf8
[mysqld]
character_set_client=utf8
character_set_server=utf8
collation_server=utf8_unicode_ci
</code></pre>

<p>And added to conf </p>

<pre><code>  'OPTIONS': {
        'read_default_file': 'full path to cnf file'
    }
</code></pre>

<p>But it also hasn't results. </p>