Re: load data infile ... with UTF-8 characters
Thanks for the reply.
I've already checked the input data. It's clean. All valid UTF-8 characters.
I finally found a solution elsewhere online. I changed the LOAD DATA statement. I now specify latin1 character set. This makes ANY byte valid. And it works.
It has one negative aspect: There is no checking for invalid UTF-8 characters. But since my input is all well-formed, valid UTF-8, this is not a problem.
Subject
Views
Written By
Posted
9024
September 05, 2015 05:42PM
2246
September 13, 2015 08:18PM
Re: load data infile ... with UTF-8 characters
2187
September 14, 2015 02:05PM
1812
September 16, 2015 01:16PM
2079
September 16, 2015 04:01PM
1698
September 17, 2015 01:21PM
1667
September 18, 2015 09:24PM
1996
September 23, 2015 11:49AM
1521
September 29, 2015 01:12AM
1765
October 02, 2015 03:51PM
1665
October 02, 2015 05:28PM
1815
October 02, 2015 09:17PM
1932
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.