ID: 20797
Comment by: olivier dot sow at alias dot fr
Reported By: carl dot landry at emergis dot com
Status: No Feedback
Bug Type: MSSQL related
Operating System: Windows NT 4.0 build 1381
PHP Version: 4.2.2
New Comment:

the probleme seems to be global to ISAPI modul
when i try to set mssql.textsize & mssql.textlimit in php.ini, these
values take effect while using php.exe but no when using php.dll (ISAPI
modul)
phpinfo return "Server default" as local and master values
using php4.4.4 on Win2KSrv SP4


Previous Comments:
------------------------------------------------------------------------

[2003-01-02 18:41:35] [email]sniper@php.net[/email]

No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.



------------------------------------------------------------------------

[2002-12-07 01:20:46] [email]iliaa@php.net[/email]

Please try using this CVS snapshot:

[url]http://snaps.php.net/php4-latest.tar.gz[/url]

For Windows:

[url]http://snaps.php.net/win32/php4-win32-latest.zip[/url]



------------------------------------------------------------------------

[2002-12-03 13:05:28] carl dot landry at emergis dot com

To adjust the 4k limitation of TEXT fields, I changed the TEXTSIZE and
TEXTLIMIT value of MSSQL (SET TEXTSIZE xxx) to a very high value to
prevent interference. This works properly.

Adjusting the "mssql.textlimit" and "mssql.textsize" values in php.ini
would allow larger than 4k results to be returned. This seems also
fine.

However, changing this limit at run time ("ini_set("mssql.textlimit",
12000); ini_set("mssql.textsize", 12000);", 12000 (int) or "12000"
string, not making a difference) would have no impact on the selected
result.
PHPINFO() shows the new adjusted value but the result would still be
limited to the value set in the PHP.INI file.

Also, "-1" (as suggested in the INI_SET function description page)
seems to limit to 4k too.

Server API: ISAPI
MSSQL Library version: 7.0

More information can be supplied if requested.

------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=20797&edit=1[/url]