set names utf8;

create database db1 character set latin1;
use db1;
show variables like 'char%';

--exec echo "戦" >$MYSQL_TEST_DIR/var/tmp/bug44411.csv

CREATE TABLE  test3 (
  `note` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--eval LOAD DATA INFILE '$MYSQL_TEST_DIR/var/tmp/bug44411.csv' REPLACE INTO TABLE test3 CHARACTER SET utf8 FIELDS ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (note)

--eval LOAD DATA INFILE '$MYSQL_TEST_DIR/var/tmp/bug44411.csv' REPLACE INTO TABLE test3 CHARACTER SET utf8 FIELDS ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (@PN2) SET note = @PN2;

select note, hex(note) from test3;

use test;
show variables like 'char%';

--eval LOAD DATA INFILE '$MYSQL_TEST_DIR/var/tmp/bug44411.csv' REPLACE INTO TABLE db1.test3 CHARACTER SET utf8 FIELDS ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (note)

--eval LOAD DATA INFILE '$MYSQL_TEST_DIR/var/tmp/bug44411.csv' REPLACE INTO TABLE db1.test3 CHARACTER SET utf8 FIELDS ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (@PN2) SET note = @PN2;

select note, hex(note) from db1.test3;