Getting \r\n newlines to display properly in Mantis database

Posted by matt_tm on Server Fault See other posts from Server Fault or by matt_tm
Published on 2011-01-12T13:21:29Z Indexed on 2011/01/12 13:55 UTC
Read the original article Hit count: 266

Filed under:
|
|
|
|

I've exported a Mantis project from one server to another and despite the MySQL SQL file (from which it was populated) showing:

(15375,'\r\n1. Log out\r\n\r\n2. When logging in, start ...

The final end-user view loses the \r\n and shows it only on one line:

1. Log out 2. When logging in, start typing 

When viewing through phpMyAdmin, I can see the record properly:

1. Log out

2. When logging in, start typing

How can I correct this behavior when displaying this data?

© Server Fault or respective owner

Related posts about mysql

Related posts about php