problem when importing

[john_zakaria]

i am importing a csv file that contains a unicode data using php my admin...

i import it but it is not displayed as uniocde for example :

al-Lujū΄ ilá Allāh : is shown as al-Luju?? il? Alla?h :


i tried to set the character

mysql_query("set names utf8");

note that when inserting al-Lujū΄ ilá Allāh from php my admin it is shown correctly but when importing it from a file named: 2fields.csv
(a csv file) it is not shown as unicode data
it is shown as al-Luju?? il? Alla?h

can anyone help me to import unicode csv file??

thnx alot

[Tgruutal]

Hello,

What you could do is use an open source ETL tool to import your csv files.

Talend Open Studio is an open source ETL tool for data integration and migration experts. It's easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component. It allows the user to get a graphical and functional view of integration processes.

For more information: http://www.talend.com/