Load data local infile changing special character
I fixed it by using CHARACTER SET UTF8 option in my query.

$loadmeth = "'".'"'."'"; 
LOAD DATA LOCAL INFILE   '$current_date/dummycsv.csv' 
       INTO TABLE tablename
       CHARACTER SET UTF8
       FIELDS TERMINATED BY ','
        ENCLOSED BY $loadmeth
       LINES TERMINATED BY '\r\n' 
       IGNORE 1 LINES;