splitting \t from spreadsheet (unicode)

[boonerite]

Hi, I used the following codes to split the "Text (Tab delimited) (*.txt)" format I saved as using my Excel

$email = fgetcsv($fp,999, "\t");

cell1 cell2
王 test@email.com

it works
$email[0] contains 王
and
$email[0] contains test@email.com

but it will result in "??" displayed in the text document instead of 王

so I tried to use Save As Unicode Text (*.txt)
it displays the unicode character as it is
but, the
$email = fgetcsv($fp,999, "\t"); can't seem to split it up anymore, even though it shows 王 test@email.com in the text file

anyone can explain why or how to rectify?
thanks!

hmm... I just confirmed that PHP doesnt seem to be able to read any text document which is encoded as UNICODE (choose SAVE AS from text editor)
The thing is, I need to read out the unicode characters in the unicoded text document

@ $fp = fopen("email.txt",'r');
$email = fgetcsv($fp,999, "\t");

This doesnt seem to work if the email.txt is in unicoded
how to make it readable ?

[Xnuiem]

i just use explode() to break the lines up.

[boonerite]

Hi, i tried, but it seem to be the same problem
the problem seem to lie at the part where it is being SAVED AS Unicode Text (*.txt)
and PHP doesnt seem to be able to read it (when I open it up to save its encoding as UNICODE or UTF-8)
why cant php read the document?
it just get stuck right at the part it tries to read the document
help~

[Xnuiem]

Why are you using UNICODE? Do you need to?

If not, just save it as a tab delimited text file.

[boonerite]

yep, due to the reason of needing to deal with chinese, korea, thai characters
help~