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

Reply via email to