#13722 [Com]: mssql text type returns only 255 char

ID: 13722 Comment by: hostmak at gmail dot com Reported By: brendan at msu dot edu Status: No Feedback Bug Type: Sybase-ct (ctlib) related Operating System: Solaris 2.7 PHP Version: 4.2.1 New Comment: problem still exists....ideas ? :| Previous Comments: ------------------------------------------------------------------------ [2002-09-14 01:00:01] php-bugs at lists dot php dot net No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2002-08-13 23:41:55] kalowsky@php.net updating version as well. ------------------------------------------------------------------------ [2002-08-13 23:41:36] kalowsky@php.net try doing a "SET TEXTSIZE <some really large number here>" in an exec command. ------------------------------------------------------------------------ [2002-07-26 23:42:43] systematic11 at comcast dot net As of version 4.2.1, this issue has still not been corrected. Perhaps the problem lies with FreeTDS. Apparently neither the CT-Lib and DB-Lib for Sybase have no use for this property (MSSQL TEXT SIZE). If you must connect to MS SQL Server from PHP, I would suggest creating an include file that is included at the top of any PHP script that needs to access the MS SQL Server. Let the include file open a connection and call a query to "set textsize 65536" or to whatever limit you want. e.g. <?php // include file for MS SQL server $HOSTNAME = "SQLServer70"; $USERNAME = "sa"; $PASSWORD = "??"; $conn = mssql_pconnect($HOSTNAME, $USERNAME, $PASSWORD); if ($conn) { mssql_query("SET TEXTSIZE 65536"); mssql_select_db("whatever", $conn); } ?> Kelly Akins ------------------------------------------------------------------------ [2002-05-21 11:52:51] vedran at quark dot fsb dot hr 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. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/13722 -- Edit this bug report at http://bugs.php.net/?id=13722&edit=1