Jump to content

[SOLVED] 4100 character limit on string length


Recommended Posts

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"];

Link to comment
Share on other sites

  • 2 months later...


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.