Re: Text output limit

If you look in the transact SQL on-line help for SET you get: SET TEXTSIZE number Specifies the size, in bytes, of text data to be returned with a SELECT statement. If you specify a TEXTSIZE of 0, the size is reset to the default (4K). Setting TEXTSIZE affects the global variable @@TEXTSIZE. The DB-Library variable DBTEXTLIMIT also limits the size of text data returned with a SELECT statement. If DBTEXTLIMIT is set to a smaller size than TEXTSIZE, only the amount specified by DBTEXTLIMIT is returned. For more information, see Microsoft SQL Server Programming DB-Library for C. you end up with a query that looks like; $q1 = "set textsize 128000 Select bigcolumn,..., from tablex"; There is a SQLServer programmers toolkit up on the www.microsoft.com sqlserver section. Download it, there is a VB example of how to do BLOBs using DDL. I have not tried it but when I get to work on monday I will see what my 6.5 box does. I have some 4-5mb BLOBs. If memory serves me, if the column is specified as text it works and if it is specified as image it mucks up. joe ECN wrote: > > Here's the situation... > > Problem Environment: > WinNT 4.0 SP 6a running IIS 4.0 > SQL Server 7.0 SP2 > PHP 3.0.11 through 3.0.16 > php3_mssql70.dll > > Problem: > Output limit of 4K or 4096 bytes when selecting long text > > Failed solutions: > setting mssql.textsize = 8096 in php.ini > setting mssql.textlimit = 8096 in php.ini > > -enelson > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net