Unicode csv to mysql

[phpnewbie112]

Hello, I have a small piece of code that successfuly insert any imported csv or txt (comma delimited) file into the mysql db but unicode characters are simply returning an empty field. pls advice how can I allow unicode chars too to be imported.

 

after uploading the file

     include "inc/MySql.php";
     $decode = utf8_decode("$target");
     $handle = fopen($decode, "r");
     while (($data = fgetcsv($handle, 10000, ",")) !== FALSE)
     {
     $result = mysql_query($sql) or die(mysql_error());
     $import="INSERT into Table(x,y,z) values('$data[0]','$data[1]','$data[2]')";
      mysql_query($import) or die(mysql_error());
      }

[discomatt]

Is your SQL table's enctype unicode/UTF?

[phpnewbie112]

collation is utf8_bin

[Mchl]

What about charset?

 

You can also use LOAD DATA INFILE to load CSV files much faster than by parsing them with php.

[phpnewbie112]

charset is also utf-8