useing PHP to read MSSQL ntext fields

set php.ini
mssql.textlimit = 40960000
mssql.textsize = 40960000
restart IIS

Solution for the following Error:
Warning: mssql_query() [function.mssql-query]: message: 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.
This is because you are using column types of like ntext instead of text. There are 2 solutions.
1. Change all ntext column types to text or
2. Your query must look like: SELECT CAST(field1 AS TEXT) AS field1 FROM table

Another Error:
Allowed memory size of 134217728 bytes exhausted

@ini_set('memory_limit','1024M');
all done!