Re: Record size limit with MS SQL 7

Frank, Thanks for the reply. Within half an hour of sending the request to the list I found a reference on the internet to the two configuration parameters you mention below. The reference I found claims that the bounds for these items are as follows: mssql.textsize: 0-64Kb mssql.textlimit: 0-2Gb Neither of these parameters were in the php.ini I received with the default download of PHP 4.0.2 from phpwin.de. It makes me wonder what else might be available for configuration. To cut a long story short, I inserted both these parameters into php.ini, set to 16,384, and the problem is solved. Thanks, again. S t u a r t . "Frank M. Kromann" wrote: > Hi, > > When you use MS SQL Server it usally sets the limit to 4096, but that can be altered. Either in > the server configuration og in php.ini. > > php.ini has two paramters for this: > > mssql.textsize = 8192 > mssql.textlimit = 8192 > > with these parameters you can set any size you want. You can read the MS SQL documentation for > exact description of the two. )I can imail that if you dont have access to it). > > The has been some troubles with setting textlimit but to my knowledge, that has been fixed. > That is I have no problems with it :-) > ' > If you are unable to build your own modules from the php cvs. Iøll be happy to email you my > copy. > > - Frank > > >Is there a size limit for the records returned from a SELECT with > >Microsoft SQL Server? I'm only getting back 4096 bytes of a much larger > >record stored in the database (a record that I put there with PHP, by > >the way). > > > >Is there a setting somewhere that I need to change? > > > >I looked through the php.ini file and only found a reference to the ODBC > >driver for restricting the length of returned data. I'm not using the > >ODBC driver. > > > >I'm using PHP 4.0.2, with Microsoft SQL Server 7, on Microsoft Windows > >NT 4 Server, with IIS (CGI mode). > > > >Any assistance most gratefully accepted. > > > >Cheers, S t u a r t . > > > > > >-- > >PHP Windows Mailing List (http://www.php.net/) > >To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > >For additional commands, e-mail: php-windows-help@lists.php.net > >To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > >