#20797 [Opn->Fbk]: 4k text limitation can be adjusted by INI_SET

ID: 20797 Updated by: iliaa@php.net Reported By: carl.landry@emergis.com -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: Windows NT 4.0 build 1381 PHP Version: 4.2.2 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2002-12-03 13:05:28] carl.landry@emergis.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 http://bugs.php.net/?id=20797&edit=1