reading unicode tab delimited text file in php
Posted: Sun Oct 28, 2007 7:40 pm
Hi All,
Recently I'm involved with a task to read a tab delimited text file in unicode and then convert them into a series of sql insert statements and then insert to mysql db.
I've successfully done the similar thing in the past with the text in ASCII using php's fgetcsv, but this time it does not work for this unicode file. In the file it has some funny characters like '®'.
Anyone had some hints on this?
Thank you very much.
Best Regards,
jim
Recently I'm involved with a task to read a tab delimited text file in unicode and then convert them into a series of sql insert statements and then insert to mysql db.
I've successfully done the similar thing in the past with the text in ASCII using php's fgetcsv, but this time it does not work for this unicode file. In the file it has some funny characters like '®'.
Anyone had some hints on this?
Thank you very much.
Best Regards,
jim