Page 1 of 1

Message body contains <br /> at end of lines

Posted: Mon Jul 20, 2009 8:01 pm
by iainlee
Script URL:http://www.spartica.net/hesk
Version of script:2.0
Hosting company:
URL of phpinfo.php:http://www.spartica.net/hesk/phpinfo.php
URL of session_test.php:http://www.spartica.net/hesk/session_test.php
What terms did you try when SEARCHING for a solution:
"<br />";magic quotes

Write your message below:

Wherever someone inputs a carriage return (Enter) or a line feed (shift Enter) into a message, the text has "<br />" in it. I am trying to access the MYSQL data using Microsoft Access via ODBC but the message field gets truncated after the first "<br />", so a lot of my messages only display "Hi <br />" in the access tables.
Is this expect behaviour and if so, can anyone suggest a workaround?

Posted: Tue Jul 21, 2009 3:03 pm
by Klemen
Yes, that is the expected behaviour as the plain text entered in the "Message" filed is getting transformed into (X)HTML code.

I never used Access so I'm not why it truncates data after<br />. That's not something I can help with.