strange ? after each char getValue() on text

Topics: Developer Forum, User Forum
Jun 6, 2009 at 1:14 PM

I tested my script getValue() function localhost, it manage to work and display without any issue.

However, I deployed to the server, which is HP-UX PHP 5.22 without iconv and mbstring.

it display ? in browser

http://yfrog.com/0twphpj

I really stuck, the ? when I copied out, it is hidden / invisible characters.

the middle actually are date in Excel, which is correct in display

Appreciate any advice on this. Thank you.

 

Developer
Jun 6, 2009 at 1:26 PM

You will need at least iconv or mbstring extension enabled when you read / write xls files. Sometimes it will work even without if there are only ASCII characters, but that is another story.

The problem is that xls in general uses UTF-16 LE. If you don't have iconv or mbstring enabled PHPExcel cannot convert to UTF-8.

 

Jun 6, 2009 at 2:00 PM
Edited Jun 6, 2009 at 2:12 PM

thank you for fast reply. by the way, that HP-UX was Big Endian, RISC, does it matter?

Developer
Jun 6, 2009 at 3:15 PM

>> by the way, that HP-UX was Big Endian, RISC, does it matter?

It doesn't matter. The iconv / mbstring takes care of this properly.