utf8mb4 encoding of csv files for import to MySQL
<p>I have been successful setting up my Ubuntu 16.04 LTS LAMPS server so that MySQL 5.7 now fully supports the utf8mb4 character sets. Asian and French character sets can be entered directly into the database front end XATAFace with no issues.</p>
<p>When I import csv files into MySQL with the phpmyadmin administrative frontend the csv files I am making now with french language characters are not being imported, throwing the familar mysql import error:</p>
<blockquote>
<h1>1366 Incorrect String value: ‘\xE9ciali…’ for column . . . .</h1>
</blockquote>
<p>I am guessing a text editor that can encode csv files as utf8mb4 is what is needed; please correct me if this is wrong. Is there a text editor on the Windows platform that would allow csv files to be encoded utf8mb4 so that I can successfully import my csvs into MySQL?</p>
<p>Any ideas how this csv import hurdle can be overcome?</p>
<p>Thanks in advance Mark, Saginaw Michigan</p>