[SOLVED] 4100 character limit on string length

[Jaguar]

I have a description field (text type) in an SQL Server 2005 database. Some of the descriptions in the database are long, 4500+ characters. When I select and try to print the descriptions, they get cut off at 4100 characters. Has anyone experienced this?

 

I tried inserting values over 4100 characters long into the database through PHP and it works, but selecting the value back gets cut off at 4100 characters in PHP.

 

$sql = "SELECT name, description
    FROM Users
    ORDER BY name;";

$result = mssql_query($sql);

while($row = mssql_fetch_assoc($result))
{
    echo $row["name"] . ":";
    echo "<br /><br />";
    echo $row["description"];
}

[Jaguar]

I found the answer in the comments of the PHP docs. Here's how you fix it if anyone stumbles across this in the future:

 

ini_set("mssql.textlimit", "65536");
ini_set("mssql.textsize", "65536"); 

[plimpton]

Another option would be to use the sqlsrv driver available directly from microsoft: http://blogs.msdn.com/sqlphp/