maria-developers team mailing list archive

Thread
Date

maria-developers team
Mailing list archive
Message #11806

SELECT INTO OUTFILE + LOAD DATA for a mixture of character and binary data

To: "Kenneth P. J. Dyer" <kenneth.dyer@xxxxxxxxxxx>, maria-developers <maria-developers@xxxxxxxxxxxxxxxxxxx>
From: Alexander Barkov <bar@xxxxxxxxxxx>
Date: Mon, 22 Apr 2019 09:14:51 +0400
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.6.1

Hi Kenneth,

I just closed this issue as "not a bug":
MDEV-13361 Regression: LOAD DATA INFILE utf8 enconding issues

Can you please document that when doing "SELECT INTO OUTFILE" followed
by "LOAD DATA INFILE" for a mixture of text and binary data, one should
use "CHARACTER SET binary" in both statements. This is needed to avoid
escape sequences to be interpreted in a wrong way at "LOAD DATA" type.

Thanks.