Bug #41489 LOAD DATA INFILE doesn't work with multibyte ENCLOSED BY (although SELECT INTO O
Submitted: 16 Dec 2008 6:32
Reporter: Stewart Smith Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:6.0.9 OS:Any
Assigned to: CPU Architecture:Any

[16 Dec 2008 6:32] Stewart Smith
Description:
LOAD DATA INFILE doesn't work with multibyte ENCLOSED BY (although SELECT INTO OUTFILE does)

also see https://bugs.launchpad.net/drizzle/+bug/308457

possibly related to http://bugs.mysql.com/bug.php?id=31677

How to repeat:
CREATE TABLE t1 (c1 VARCHAR(256));
INSERT INTO t1 (c1) VALUES ('☠');
SELECT HEX(c1) FROM t1;
HEX(c1)
E298A0
SELECT * INTO OUTFILE 'MYSQLTEST_VARDIR/tmp/bug32533.txt' FIELDS ENCLOSED BY '☢' FROM t1;
TRUNCATE t1;
SELECT HEX(LOAD_FILE('MYSQLTEST_VARDIR/tmp/bug32533.txt'));
HEX(LOAD_FILE('MYSQLTEST_VARDIR/tmp/bug32533.txt'))
E298A2E298A0E298A20A
LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/bug32533.txt' INTO TABLE t1 FIELDS ENCLOSED BY '☢';

Suggested fix:
load the data back in!
[16 Dec 2008 6:33] Stewart Smith
at the very least a docs bug as the error says to look at manual... and there's nothing there about multibyte (that i could easily see)