note 62787 added to ref.mbstring

From: 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

« previous php.notes (#105153) next »