Bug #38805 [Com]: PDO Truncates Text from SQL Server Text Data Type Field

From: Date: Thu, 06 Nov 2014 20:44:01 +0000
Subject: Bug #38805 [Com]: PDO Truncates Text from SQL Server Text Data Type Field
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-188491@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
 Comment by:         desiovincenzo at gmail dot com
 Reported by:        gkrajci at arescorporation dot com
 Summary:            PDO Truncates Text from SQL Server Text Data Type
                     Field
 Status:             Closed
 Type:               Bug
 Package:            PDO related
 Operating System:   Windows NT PBMA-WB2 5.2 build 37
 PHP Version:        5.1.6
 Assigned To:        ssufficool
 Block user comment: N
 Private report:     N

 New Comment:

hi all

you can solve this issue by using the sql convert function as below : 

SELECT CONVERT(TEXT,field) as field_name from table

hope it is useful for someone

byez


Previous Comments:
------------------------------------------------------------------------
[2012-09-13 04:35:07] 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/.

 For Windows:

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



------------------------------------------------------------------------
[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.

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


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 (#188491) next »