title: Receiving a truncated string value in a SQL Server query from PHP script
body: <p>I am executing a SQL query inside a PHP script. The query is executed against a SQL Server database, using the PDO class. I am retrieving the results of the query using <code>$result-&gt;fetch(PDO::FETCH_ASSOC)</code>.</p>
  
  <p>One of the columns in the result is a string that could be in excess of 256 characters, but when I access this value in PHP, the string is always truncated at 256 characters. The value itself is basically just a sentence i.e., reasonable for its length to exceed 256 characters, but not 1024 characters.</p>
  
  <p>The MS SQL DB stores the data in (effectively) a <code>VARCHAR(1024)</code> column. If I run the query in Visual Studio, there is no truncation - I get the full string returned.</p>
  
  <p>I can obviously modify the query and the PHP code (not the configuration), but not the MS SQL DB.</p>
  
  <p>Where is the truncation happening? How do I retrieve the full string in my PHP code?</p>