Re: Re: iconv is messing up a spreadsheet generated by the Spreadsheet Excel Writer

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, 14 Jan 2009 11:33:25 +0200, Thodoris wrote:

>> On Tue, 13 Jan 2009 15:51:01 +0200, Thodoris wrote:
>>
>>   
>>> Hi gang,
>>>     I am generating a spreadsheet using the contents of a mysql table. I 
>>> guess that there is something in the data that causes iconv used in the 
>>> module's script to generate this error:
>>>
>>> *Notice*: iconv() [function.iconv 
>>> <file:///C:/Documents%20and%20Settings/tgol/Local%20Settings/Temp/function.iconv>]: 
>>> Detected an incomplete multibyte character in input string in 
>>> */usr/local/share/pear/Spreadsheet/Excel/Writer/Worksheet.php* on line 
>>> *1547*
>>>
>>> This causes the production of weird characters in a cell in the 
>>> spreadsheet and after that cell everything is printed out of order.
>>>
>>> The data in the mysql table are filtered for non-printable character 
>>> before the data import.
>>>     
>>
>> What data goes into that cell?
>>   
> 
> I am selecting from a mysql table where only text and numeric data exist.
> 
>> Can you provide a hex dump of the data?
>>   
> 
> I am no sure how to do that in that case :-( .
> 

<?php echo bin2hex ($theData), "\n"; ?>

What's the output of:

  SHOW VARIABLES LIKE 'character_set%'

What's the character set of the column you get the data from?


/Nisse

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux