Re: load data infile ... with UTF-8 characters
Posted by: Bruce Malmat
Date: September 14, 2015 02:05PM

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.

Options: ReplyQuote

Written By
Re: load data infile ... with UTF-8 characters
September 14, 2015 02:05PM

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.