Truncated CONVERT(ntext as TEXT) - how to retrieve all the text?

[benphp]

Using mssql_query to hit a MS SQL db that has a table with "ntext" as the datatype for "MLTEXT"

 

 

SELECT

  MLID,

  CAST(MLTEXT AS TEXT )
FROM ANSWER
WHERE
  NID = 1201

 

Returns only 110 chars of the MLTEXT. I tried modifying the PHP.INI file to set the max text length, but that didn't seem to make a difference. I tried:

 

ini_set ( 'mssql.textlimit' , '2147483647' );
ini_set ( 'mssql.textsize' , '2147483647' );
mssql_query("SET TEXTSIZE 2147483647");

 

as well, but still the same results. Is there a better way to fetch the data? Is it the db that's limiting the text length?

 

Thanks -