Re: Record size limit with MS SQL 7

Hello Stuart, You're not alone! I'm also using PHP 4.02 with MS-SQL 7.0, and I have that same problem. Due to the fact that I had in the past also the problem, that a varchar record (in MS-SQL up to 8,000 characters) was cutted off after 256 chars (or so, would have to look), and changing the datatype in the DB helped, .... sorry I'm chatting around :-).... In short: I assume that the developers took the limits of mySQL also for MSSQL70. I already wanted to write a "Bug-Report" (meaning posting in the dev-list :-), but the new release came inbetween. I'll intall the new version tonight, and if it doesn't solve the prob, we should act, because I don't know any bigger datatype in MS-SQL than text (2,147,483,647 chars), and so I haven't any idea for a workaround like that last time. But one BIG QUESTION: How can I check if the whole record > 4kB is in the Database, of if I didn't even get it in?? Best regards, Thomas Stuart V Begg wrote: > 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