MySQL LOAD DATA LOCAL INFILE Changing Special Characters

MySQLPHP

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.

Best Answer

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;
Related Question