On Fri, 2009-03-27 at 17:40 +0800, Ai Leen wrote: > Hi Everyone, > > I need to export data from database with UTF-8 encoding to an csv file. I am > outputing html tables with the Content Type set to msexcel. > > The chinese texts came out as symbols. I tried > using mb_convert_encoding the text from UTF-8 to UTF-16LE > iconv from UTF8 to gb2312 > iconv from UTF-8 to cp1252 > > Can anyone who has successfully export english text with chinese characters > mixed in to CSV help? > > Thank you very much, > Ai Leen > > Strictly speaking, a csv file won't contain HTML markup, so you should probably just stick to delimited value lines in your file. Have you tried changing the Content Type to text/plain and then save your PHP script as utf-8. It's this last one that sometimes causes problems, as I believe it is needed for PHP to correctly output utf-8.
Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php