title: Text data getting cut off when returned from DB
body: <p>When I use MSSQL in php to read a field that has veru long content, I get an error</p>
  
  <blockquote>
    <p>Warning: mssql_query() [function.mssql-query]: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier</p>
  </blockquote>
  
  <p>I searched online and find out to solve this problem, and find out that I need to cast the result to get readable text.</p>
  
  <pre><code>SELECT CAST(Content AS TEXT) AS Content FROM myTable
  </code></pre>
  
  <p>However, another problem I am getting is that the text data is truncated after 4096 characters. Is there anyway to further reading the text, or another option to cast the returned data? </p>
  
  <p>Thanks</p>