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

From: Date: Fri, 19 Oct 2001 17:01:40 +0000
Subject: Bug #13722 Updated: mssql text type returns only 255 char
References: 1  Groups: php.dev 
Request: Send a blank email to php-dev+get-68431@lists.php.net to get a copy of this message 
ID: 13722
User updated by: brendan@msu.edu
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:

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?

Previous Comments:
------------------------------------------------------------------------

[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

Thread (3 messages)

« previous php.dev (#68431) next »