Load data local infile changing special character i am using load data local infile function to insert data from csv to database. Everything works fine. But the word CLOUTÉ is replacing with CLOUTÃ‰. I have no idea, how to prevent it.
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;