Re: load data infile ... with UTF-8 characters
Posted by:
Rick James
Date: October 02, 2015 03:51PM
> The e2 80 9c and e2 80 9d codes are the correct left- and right-quote encodings.
Yes, for utf8. For utf16, the hex would be (I think) 20 1C and 20 1D.
> LINES TERMINATED BY '\r\n'
That is normally useful for data coming from Windows. For Unix source, remove the "\r".
As for why it works / doesn't from one week to the next -- Well, something changed. Is the data changing? Maybe the quotes are on odd-numbered rows instead of even-numbered? (To go along with the "\r" suggestion.)
Subject
Views
Written By
Posted
8182
September 05, 2015 05:42PM
1960
September 13, 2015 08:18PM
1849
September 14, 2015 02:05PM
1544
September 16, 2015 01:16PM
1728
September 16, 2015 04:01PM
1441
September 17, 2015 01:21PM
1406
September 18, 2015 09:24PM
1659
September 23, 2015 11:49AM
1286
September 29, 2015 01:12AM
Re: load data infile ... with UTF-8 characters
1481
October 02, 2015 03:51PM
1380
October 02, 2015 05:28PM
1496
October 02, 2015 09:17PM
1670
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.