note 62787 added to ref.mbstring
| From: | peterkehl at osu1 dot php dot net | Date: | Thu, 09 Mar 2006 16:34:36 +0000 |
| Subject: | note 62787 added to ref.mbstring | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-105153@lists.php.net to get a copy of this message | ||
UTF-16LE solution for CSV for Excel by Eugene Murai works well:
$unicode_str_for_Excel = chr(255).chr(254).mb_convert_encoding( $utf8_str, 'UTF-16LE',
'UTF-8');
However, then Excel on Mac OS X doesn't identify columns properly and its puts each whole row
in its own cell. In order to fix that, use TAB "\\t" character as CSV delimiter rather
than comma or colon.
You may also want to use HTTP encoding header, such as
header( "Content-type: application/vnd.ms-excel; charset=UTF-16LE" );
----
Server IP: 85.116.0.130
Probable Submitter: 212.158.230.131
----
X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER
autolearn=no version=2.64
----
Manual Page -- http://www.php.net/manual/en/ref.mbstring.php
Edit -- http://master.php.net/note/edit/62787
Del: integrated -- http://master.php.net/note/delete/62787/integrated
Del: useless -- http://master.php.net/note/delete/62787/useless
Del: bad code -- http://master.php.net/note/delete/62787/bad+code
Del: spam -- http://master.php.net/note/delete/62787/spam
Del: non-english -- http://master.php.net/note/delete/62787/non-english
Del: in docs -- http://master.php.net/note/delete/62787/in+docs
Del: other reasons-- http://master.php.net/note/delete/62787
Reject -- http://master.php.net/note/reject/62787
Search -- http://master.php.net/manage/user-notes.php