text field truncation with sql server
| From: | Bruce Cowin | 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