Bug #13722: mssql text type returns only 255 char

From: Date: Thu, 18 Oct 2001 02:19:35 +0000
Subject: Bug #13722: mssql text type returns only 255 char
Groups: php.dev 
Request: Send a blank email to php-dev+get-68181@lists.php.net to get a copy of this message
From: brendan@msu.edu Operating system: Solaris 2.7 PHP version: 4.0.6 PHP Bug Type: *Configuration Issues Bug description: mssql text type returns only 255 char 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 bug report at: http://bugs.php.net/?id=13722&edit=1

« previous php.dev (#68181) next »