title: Mysql unable to import csv files
body: <p>I want to clarify that i browse similar questions about file encoding and importing csv files to Mysql. None of these worked for me.</p>
  
  <p>The situation is like this:</p>
  
  <p>i was in charge of the task of creating a spring boot application which generates csv files filled with random data to populate a database (each csv file correspond to a table in the DB).</p>
  
  <p>the first scenario was to import these .csv files into Oracle 12c. There was no problem, i done it, there was no errors in the data.</p>
  
  <p>The actual problem is using the same .csv files to import them into Mysql, it is not possible.</p>
  
  <p>Clarifying both Databases (Oracle and Mysql) have both the same tables with the equivalent Data Types</p>
  
  <p>I tried:</p>
  
  <ul>
  <li><strong>LOAD IN FILE</strong> option but the query never completes (it never shows any error message).</li>
  <li><p>Exporting the data from Oracle (from SQLDeveloper) into a .csv file and then import it in Mysql, i got the same error below.</p></li>
  <li><p>the <strong>Data Table Import Wizard</strong> from Mysql-workbench and it says:</p></li>
  </ul>
  
  <blockquote>
    <p>Can't analyze file, please try to change encoding type, if that doesn't help, maybe the file is not: csv, or the file is empty.</p>
  </blockquote>
  
  <p>Followed by:</p>
  
  <blockquote>
    <p>Unhandled exception: 'ascii' codec can't encode character u'\xcd' in position 8: ordinal not in range(128).</p>
  </blockquote>
  
  <p>I browsed questions about the encoding but none works to my case. And i'm pretty sure that i set the encoding to UTF-8 in my spring boot application.
  My file writer has it:</p>
  
  <pre><code>writer = new OutputStreamWriter(fileOutputStream, StandardCharsets.UTF_8);
  </code></pre>
  
  <p>How is it possible that the generated .csv files work perfectly in Oracle but no in Mysql?</p>
  
  <p>Aditional info:</p>
  
  <ul>
  <li><p>springboot 2.0.3.RELEASE</p></li>
  <li><p>Java version 1.8.0_162</p></li>
  </ul>