Re: Exporting text with chinese characters in CSV
| From: | Ashley Sheridan | Date: | Fri, 27 Mar 2009 09:59:20 +0000 |
| Subject: | Re: Exporting text with chinese characters in CSV | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-290741@lists.php.net to get a copy of this message | ||
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