note 14440 deleted from function.mssql-query by cmb
| From: | cmb@php.net | Date: | Sun, 23 Jun 2019 14:27:22 +0000 |
| Subject: | note 14440 deleted from function.mssql-query by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-211384@lists.php.net to get a copy of this message | ||
Note Submitter: wraithgar at hotmail dot com
----
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.