Posted by Gazchurchend on 11/22/05 12:19

Hi

Ive been using PHP to query data from SQL Server using MSSQL_QUERY for
a while now, but recently noticed a problem. I have a notes field in
the database (varchar 6000) for entering text. When reading out the
data with a simple SELECT statement I noticed it would only get 256
characters in the MSSQL_FETCH_ARRAY result. Don't know how I missed
this before. Obviously a significant number!
I checked the INI file for any settings. The MSSQL.TEXTSIZE and
MSSQL.TEXTLIMIT are both set to maximum limits, if this has anything to
do with it.

Does anyone know how to get round this problem, I have tried all the
getting methods I know all of which do the same.

Thanks in advance.

[Back to original message]