#19184 [NEW]: nl2br in MySQL blob fields

From: jpleite@ip.pt Operating system: Linux PHP version: 4.2.1 PHP Bug Type: Output Control Bug description: nl2br in MySQL blob fields A blob field is filled in a page as a <textarea>. Obviously the text is input formatted, with ENTER to split some lines from others. This text is to be seen in a "normal" (with no input facility, eg, without any <textarea> field) html page, and I want it to be seen exactly as entered. My code for the "normal" page is: $str="<table><tr><td>..."; ... $str.=nl2br($row[blobfield]); ... echo($str); However the result is that the full text is not seen. If I change it to: $str="<table><tr><td>..."; ... $str.=$row[blobfield]; ... echo($str); the text is seen, but unformatted. -- Edit bug report at http://bugs.php.net/?id=19184&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=19184&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=19184&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=19184&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=19184&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=19184&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=19184&r=support Expected behavior: http://bugs.php.net/fix.php?id=19184&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=19184&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=19184&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=19184&r=globals