I'm working on code that retrives data from Text/nText fields of mssql database. In ASP, the output is accurate and complete with "select * from table_name" but in PHP, it generated "UNICODE conversion error" so i modified the query with SUBSTRING() and now the query runs smooth both in ASP and PHP without any error. But now the problem is that, if the size of output of query is greater than 8094, it generate this error "Warning: MS SQL message: Cannot sort a row of size 8423, which is greater than the allowable maximum of 8094. (severity 16)" both in ASP code and in PHP and if the output of the query is less than 8096 characters, ASP displays the result correctly but PHP only displays 256 character and the rest of the data is not displayed. I have updated the "mssql.textlimit & mssql.textsize" fields to its max. limit in the php.ini file but again the results are same. Plz help me in this regard.
Moon
