← Back to team overview

maria-developers team mailing list archive

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


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.