>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #3344249. --> Reported by: [juandels3](https://www.drupal.org/user/3565972) Related to !12 >>> <h3 id="summary-problem-motivation">Problem/Motivation</h3> <p>When importing a csv containing strings in UTF-8 character encoding format an error occurs when launching a query to the database.</p> <div class="codeblock"> <pre><span style="color: #000000"><span style="color: #0000BB">&lt;?php<br>Drupal</span><span style="color: #007700">\</span><span style="color: #0000BB">Core</span><span style="color: #007700">\</span><span style="color: #0000BB">Database</span><span style="color: #007700">\</span><span style="color: #0000BB">DatabaseExceptionWrapper</span><span style="color: #007700">: </span><span style="color: #0000BB">SQLSTATE</span><span style="color: #007700">[</span><span style="color: #0000BB">HY000</span><span style="color: #007700">]: </span><span style="color: #0000BB">General error</span><span style="color: #007700">: </span><span style="color: #0000BB">1267 Illegal mix of collations </span><span style="color: #007700">(</span><span style="color: #0000BB">utf8_general_ci</span><span style="color: #007700">,</span><span style="color: #0000BB">IMPLICIT</span><span style="color: #007700">) and (</span><span style="color: #0000BB">utf8mb4_general_ci</span><span style="color: #007700">,</span><span style="color: #0000BB">COERCIBLE</span><span style="color: #007700">) for </span><span style="color: #0000BB">operation </span><span style="color: #DD0000">'='</span><span style="color: #007700">: </span><span style="color: #0000BB">SELECT n</span><span style="color: #007700">.</span><span style="color: #0000BB">tid FROM </span><span style="color: #007700">{</span><span style="color: #0000BB">taxonomy_term_field_data</span><span style="color: #007700">} </span><span style="color: #0000BB">n WHERE n</span><span style="color: #007700">.</span><span style="color: #0000BB">name </span><span style="color: #007700">= :</span><span style="color: #0000BB">uid </span><span style="color: #007700">AND </span><span style="color: #0000BB">n</span><span style="color: #007700">.</span><span style="color: #0000BB">vid </span><span style="color: #007700">= :</span><span style="color: #0000BB">vid</span><span style="color: #007700">; Array ( [:</span><span style="color: #0000BB">uid</span><span style="color: #007700">] =&gt; </span><span style="color: #0000BB">Alcal&#65533; de Henares </span><span style="color: #007700">[:</span><span style="color: #0000BB">vid</span><span style="color: #007700">] =&gt; </span><span style="color: #0000BB">municipios_madrid </span><span style="color: #007700">) </span><span style="color: #0000BB">en Drupal</span><span style="color: #007700">\</span><span style="color: #0000BB">taxonomy_import</span><span style="color: #007700">\</span><span style="color: #0000BB">Form</span><span style="color: #007700">\</span><span style="color: #0000BB">create_taxonomy</span><span style="color: #007700">() (</span><span style="color: #0000BB">linea 148 de </span><span style="color: #007700">/var/</span><span style="color: #0000BB">www</span><span style="color: #007700">/</span><span style="color: #0000BB">html</span><span style="color: #007700">/</span><span style="color: #0000BB">web</span><span style="color: #007700">/</span><span style="color: #0000BB">modules</span><span style="color: #007700">/</span><span style="color: #0000BB">contrib</span><span style="color: #007700">/</span><span style="color: #0000BB">taxonomy_import</span><span style="color: #007700">/</span><span style="color: #0000BB">src</span><span style="color: #007700">/</span><span style="color: #0000BB">Form</span><span style="color: #007700">/</span><span style="color: #0000BB">ImportForm</span><span style="color: #007700">.</span><span style="color: #0000BB">php</span><span style="color: #007700">).<br></span><span style="color: #0000BB">?&gt;</span></span></pre></div> <h4 id="summary-steps-reproduce">Steps to reproduce</h4> <p>In a database with collation 'utf8_unicode_ci' (use the query "SELECT @@character_set_database, @@collation_database;" to check), import a csv file containing strings with UTF-8 format (such as '&aacute;, &eacute;, &iacute;, &oacute;, &uacute;, &ntilde;...). When importing the .csv, you will reproduce the exception.</p> <h3 id="summary-proposed-resolution">Proposed resolution</h3> <p>Encode the string "$data[0]" to UTF-8 before launching the query to the database.</p> <h3 id="summary-remaining-tasks">Remaining tasks</h3> <p>Working on a patch.</p> <h3 id="summary-ui-changes">User interface changes</h3> <p>None.</p> <h3 id="summary-api-changes">API changes</h3> <p>None.</p> <h3 id="summary-data-model-changes">Data model changes</h3> <p>None.</p>