Text data getting cut off when returned from DB
===

When I use MSSQL in php to read a field that has veru long content, I get an error

> 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

I searched online and find out to solve this problem, and find out that I need to cast the result to get readable text.

    SELECT CAST(Content AS TEXT) AS Content FROM myTable

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? 

Thanks
