Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Question Using MSSQL_QUERY
November 22, 2005, 10:19 am
rate this thread
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.
Re: Question Using MSSQL_QUERY
Maybe this helps:
DB-Library applications and applications using the SQL Server ODBC drivers
from SQL Server version 6.5 or earlier support only a maximum of 255 bytes
of character data. If these applications attempt to retrieve character
parameters of SQL Server version 7.0 or later, or result set columns
containing more than 255 bytes of data, the character data is truncated at
I once had the same problem under IIS with VBscript. Upgrading the drivers
helped solving it.
Look at M$-site for a MDAC upgrade.