text field truncation with sql server

From: Date: Fri, 13 Jul 2007 04:37:57 +0000
Subject: text field truncation with sql server
Groups: php.general 
Request: Send a blank email to php-general+get-258743@lists.php.net to get a copy of this message
I have a simple page that displays a record from the sql server database. One of the fields is a text field and keeps getting truncated at 3980 characters. I searched and saw someone had reported this as a PDO bug so I'm not using PDO anymore, but I'm still getting the truncation. Anyone know about this or have a work around? Here is the code. It's the body field that is a text field. I've checked the field in the database and it definitely has more data than is displayed. $cn = mssql_connect($myserver, $myuser, $mypwd); mssql_select_db($mydb, $cn); $result = mssql_query("select * from emails where id = $emailid", $cn); $row = mssql_fetch_array($result, MSSQL_ASSOC); echo "<ul>"; echo "<li><b>Id:</b> " . $row['id'] . "</li>"; echo "<li><b>From:</b> " . $row['mailfrom'] . "</li>"; echo "<li><b>To:</b> " . $row['mailto'] . "</li>"; echo "<li><b>Cc:</b> " . $row['mailcc'] . "</li>"; echo "<li><b>Subject:</b> " . $row['subject'] . "</li>"; echo "<li><b>Date:</b> " . $row['sentdate'] . "</li>"; echo "<li><b>Body:</b><br> " . nl2br($row['body']) . "</li>"; echo "</ul>"; Thanks for any help. Regards, Bruce

« previous php.general (#258743) next »