Bug #13722 Updated: mssql text type returns only 255 char

ID: 13722 Updated by: vedran@quark.fsb.hr Reported By: brendan@msu.edu Status: Open Bug Type: Sybase-ct (ctlib) related Operating System: Solaris 2.7 PHP Version: 4.0.6 New Comment: I have 4.1.2 and It's still not fixed. Running my .php that has a query "SELECT sometexttypefield FROM sometable"; with /usr/bin/php4 results in ;FATAL: emalloc(): Unable to allocate -2147483648 bytes. So it's definately some a bug and it probably can be solved if we know where this mailloc is called. Previous Comments: ------------------------------------------------------------------------ [2001-10-19 13:01:39] brendan@msu.edu Then there still exists a problem with the sybase-ct support for mssql, in that there is no way to specify a TEXTSIZE that allows PHP to support MSSQL 7.0's TEXT type. Is there not? ------------------------------------------------------------------------ [2001-10-19 12:55:06] fmk@php.net When you use subase-ct and FreeTDS you are not using the mssql extension, and all the settings in the ini file for mssql is not used. The settings you are refering to works when you use the mssql extension, though that extension is only available on Win32 platforms. ------------------------------------------------------------------------ [2001-10-17 22:19:34] brendan@msu.edu Built with: (edited config template to remove uneccessary sybase libs that are not included with freetds -lsybtcl -lcomn -lcs ) ./configure --prefix=/home/username/php --with-sybase-ct=../../freetds --with-pgsql=/home/postgres/pgsql --with-apache=../../apache_1.3.22 -enable-track-vars --with-imap=../../imap make make install FreeTDS verified functional using test scripts, and functional through Perl to same DB that PHP is connected to. Problem: Text type returns only first 255 chars Expected: >540 chars (can retrieve through FreeTDS/Perl) php.ini contains uncommented lines: mssql.textlimit=8192 mssql.textsize=8192 Query to MSSQL Server: SELECT @@TEXTSIZE Returns: 4096 Expected: 8192 (due to php.ini settings?) Query to MSSQL Server: SET TEXTSIZE 8192 SELECT @@TEXTSIZE Returns: 8192 Expected: 8192 Suspect: php.ini not being read But: other setting changes show up on php_info() Suspect: mssql settings not being read properly from php.info? Query to MSSQL Server: SET TEXTSIZE 8192 SELECT our_col FROM our_table; Returns: only first 255 chars of our_col Expected: all 500+ chars in field ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=13722&edit=1