Re: Record size limit with MS SQL 7

From: Date: Tue, 17 Oct 2000 16:44:49 +0000
Subject: Re: Record size limit with MS SQL 7
Groups: php.windows 
Request: Send a blank email to php-windows+get-3301@lists.php.net to get a copy of this message
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 > > >

« previous php.windows (#3301) next »