Re: blob data to infile
Posted by: Charles Kaminski
Date: May 04, 2017 10:53AM

Turns out that MySQL was escaping certain characters not represented in the complex delimiters.

The solution was to tell MySQL not to escape any characters:

FIELDS TERMINATED BY '~~|~~' ESCAPED BY ''

Options: ReplyQuote


Subject
Views
Written By
Posted
1472
April 27, 2017 12:07PM
698
April 27, 2017 12:13PM
879
April 28, 2017 02:53PM
Re: blob data to infile
718
May 04, 2017 10:53AM


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.