Bug #13722: mssql text type returns only 255 char
| From: | brendan at msu dot edu | 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