note 14440 added to function.mssql-query.php

From: Date: Tue, 31 Jul 2001 17:49:59 +0000
Subject: note 14440 added to function.mssql-query.php
Groups: php.notes 
Request: Send a blank email to php-notes+get-16122@lists.php.net to get a copy of this message
We are using --with-sybase=/opt/sybase-11.9.2/ We had a problem at first getting mssql results w/ a text field to return anything more than 4096 bytes. The mssql.textlimit and mssql.textsize parameters in php.ini had no effect on this. Turns out you can control this from the mssql end w/ one simple query mssql_query("set textsize 65536"); Of course, 65536 is just an example, use whatever value you need to get back as a max. We tested it and the setting stayed through the whole connection, no need to run that query before EVERY one of your real queries. However, it didn't seem to retain across sessions.. (sorry, can't simply run the query once and forget about it) Hope this helps others who are banging their head on a wall like we were. http://www.php.net/manual/en/function.mssql-query.php

« previous php.notes (#16122) next »