Exporting text with chinese characters in CSV
| From: | Ai Leen | Date: | Fri, 27 Mar 2009 09:40:42 +0000 |
| Subject: | Exporting text with chinese characters in CSV | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-290740@lists.php.net to get a copy of this message | ||
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