Chars missing when displaying w php from mysql

[gustavb]

Hi,

I have a slight problem with an PHP-application, and the consultant who wrote it is nowhere to be found :-(.

The error occurs when displaying a TEXT-column from mySQL-database with PHP, some way the string in the database loses about half the string. So when I look at it the string in the database might look like this " (lots of chars)...... we went to the forrest." and when its displayed " (lots of chars) ...... we wen". This has someting with the length of the string to do, but I cant figure out how... :-(

The codeline responsible for printing the string:
"
$sheet->write($line, 0, preg_replace("/[\n\r]/", " ", stripslashes($ag["answer"])));
"

I'm no PHP-guru, so please help me ;-)

Regards
G Bergqusit

[vronsky]

Do the database data type is text or varchar?

[gustavb]

The Datatype i TEXT in the database.

/GB

[toxic_brain]

what does a mere

echo $ag["answer"] ; 

return?