Re: Retrieving "text" > 4K SQL Server 7.0

if you use the PHP MSSQL driver, find a line in php.ini : mssql.textlimit = 4096 mssql.textsize = 4096 and change there are value to you wanted. elman Al wrote:

Setup: PHP 4 and Apache on NT 4; SQL Server 7.0 on NT 4, Unified ODBC using SQL Server ODBC driver. How does one go about getting "text" data out of SQL Server 7.0 using PHP's Unified ODBC drivers? This is "text" data... not varchar()! I can PUT as much data as I want into a "text" column in a table, but I can only GET 4096 bytes in a SELECT. Reading the SQL 7.0 docs, it says 4K is the default amount of data that's allowed in a SELECT statement. However, the same docs say that when using ODBC, the driver sets it to return the max allowed for the machine (~2GB). I can whip up a Delphi app to use the same ODBC DSN and pull all the "text" data out of the column, but I just can't get it to work using PHP. I realize there's lots of hidden stuff in Delphi's BDE, so I know that's not a valid comparison. I've also tried using the PHP MSSQL drivers and I get the same results, so I'm sure there's something I'm missing on the SQL Server 7.0 end. Help?!?! -Al