Re: load data infile ... with UTF-8 characters
Posted by:
Rick James
Date: September 16, 2015 01:16PM
Is the file really utf8? Or is it something generated by Windows Office?
Is the table/column declared CHARACTER SET utf8?
Can you provide the hex of the characters; this will help discuss it further. Here is a list of quotes, with hex codes:
http://mysql.rjweb.org/doc.php/charcoll#quotes
Subject
Views
Written By
Posted
8310
September 05, 2015 05:42PM
1993
September 13, 2015 08:18PM
1885
September 14, 2015 02:05PM
Re: load data infile ... with UTF-8 characters
1577
September 16, 2015 01:16PM
1769
September 16, 2015 04:01PM
1468
September 17, 2015 01:21PM
1433
September 18, 2015 09:24PM
1696
September 23, 2015 11:49AM
1312
September 29, 2015 01:12AM
1518
October 02, 2015 03:51PM
1410
October 02, 2015 05:28PM
1529
October 02, 2015 09:17PM
1706
October 02, 2015 09:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.