[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

[=OTS=G-Man]

are you importing from phpMyAdmin or right from mysql?

because i know php does not officially support Unicode yet(well last time I checked about a year ago)

so I would suggest using something like a mysql front end like SQLyog (don't know if it support importing or not, but I use it for management of my server) or something like it.

[john_zakaria]

Originally Posted by =OTS=G-Man

are you importing from phpMyAdmin or right from mysql?

because i know php does not officially support Unicode yet(well last time I checked about a year ago)

so I would suggest using something like a mysql front end like SQLyog (don't know if it support importing or not, but I use it for management of my server) or something like it.

i'm using php my admin and i tried to insert romanized data and it enters very well.. but when importing it from a csv file .. it did not enter as romanized.

i dont know how to fix this problem
but i really need it