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

Thanks!! -Al On Fri, 17 Aug 2001 14:17:28 +0800, elman.cheng@eha.net (Elman Cheng) wrote: >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 >> > >