Bug #38805 [Opn->Csd]: PDO Truncates Text from SQL Server Text Data Type Field

From: Date: Thu, 13 Sep 2012 04:35:07 +0000
Subject: Bug #38805 [Opn->Csd]: PDO Truncates Text from SQL Server Text Data Type Field
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-173396@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=38805&edit=1

 ID:                 38805
 Updated by:         ssufficool@php.net
 Reported by:        gkrajci at arescorporation dot com
 Summary:            PDO Truncates Text from SQL Server Text Data Type
                     Field
-Status:             Open
+Status:             Closed
 Type:               Bug
 Package:            PDO related
 Operating System:   Windows NT PBMA-WB2 5.2 build 37
 PHP Version:        5.1.6
-Assigned To:        
+Assigned To:        ssufficool
 Block user comment: N
 Private report:     N

 New Comment:

This bug has been fixed in SVN.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.

 For Windows:

http://windows.php.net/snapshots/
 
Thank you for the report, and for helping us make PHP better.




Previous Comments:
------------------------------------------------------------------------
[2011-12-04 02:48:51] ssufficool@php.net

This bug has been fixed in SVN.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
 
Thank you for the report, and for helping us make PHP better.



------------------------------------------------------------------------
[2010-12-17 21:07:48] kalle@php.net

.

------------------------------------------------------------------------
[2010-03-04 20:55:06] juan dot pineda at resultstel dot com

I solved this problem by adding to my php script a TEXTSIZE that is less than the allowed memory
from the MSSQL server. 

Remember, all the number are in Bytes, so I kept playing with the numbers, until this worked:
// ranges from 0 - 3145728 = 3Megabytes.  Default to 4096.
$sql = "SET TEXTSIZE 3145728";
mssql_query($sql, $db) or die(mssql_get_last_message());

Remember to always know what the allowed upload size for your server is.

I hope this helps someone

------------------------------------------------------------------------
[2010-02-12 16:57:02] sfox@php.net

Those changes are still in SVN. That means the TEXTLIMIT var is being set to its highest possible
value, which in turn means that truncation shouldn't be an issue now.

$pdo->query('SET TEXTSIZE 300000');

should work from PHP 5.2.11 up, it just needs doccing.

------------------------------------------------------------------------
[2010-02-12 09:05:28] philipp at servicemail24 dot de

This problem is actually fixed in cvs:

http://www.mail-archive.com/php-cvs@lists.php.net/msg40731.html
http://www.mail-archive.com/php-cvs@lists.php.net/msg40711.html

Here is the working source code:

http://cvs.php.net/viewvc.cgi/php-src/ext/pdo_dblib/

I have no idea why these fixes aren't included in the 5.2 and 5.3 releases!

@sfox can you ensure that pdo_dblib is updated with the release of 5.2.13 and 5.3.2?

------------------------------------------------------------------------


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

    https://bugs.php.net/bug.php?id=38805


-- 
Edit this bug report at https://bugs.php.net/bug.php?id=38805&edit=1

Thread (42 messages)

« previous php.bugs (#173396) next »