Bug #1525 Updated: It's not possible to receive from MSSQL TEXT field more than 4K data

ID: 1525 Updated by: fmk Reported By: vin@dor.ru Status: Closed Bug Type: MSSQL related Assigned To: Comments: you can set the following php3.ini options: mssql.textsize = 8192 mssql.textlimit = 8192 textlimit can be anything from 0 to text limit and textsize can be anything from 0 to 2Gb. From the MS SQL Server docs: SET TEXTSIZE (T-SQL) Specifies the size of text and ntext data returned with a SELECT statement. Syntax SET TEXTSIZE {number | @number_var} Arguments number | @number_var Is the size (an integer) of text data, in bytes. The maximum setting for SET TEXTSIZE is 2 gigabytes (GB), specified in bytes. A setting of 0 resets the size to the default (4 KB). Remarks Setting SET TEXTSIZE affects the @@TEXTSIZE function. The DB-Library variable DBTEXTLIMIT also limits the size of text data returned with a SELECT statement. If DBTEXTLIMIT is set to a smaller size than TEXTSIZE, only the amount specified by DBTEXTLIMIT is returned. For more information, see Programming DB-Library for C. The SQL Server ODBC driver and Microsoft OLE DB Provider for SQL Server automatically set TEXTSIZE to 2147483647 when connecting. The setting of set TEXTSIZE is set at execute or run time and not at parse time. Permissions SET TEXTSIZE permissions default to all users. Full Bug description available at: http://bugs.php.net/?id=1525