Edit report at https://bugs.php.net/bug.php?id=38805&edit=1
ID: 38805 Updated by: [email protected] Reported by: gkrajci at arescorporation dot com Summary: PDO Truncates Text from SQL Server Text Data Type Field -Status: Open +Status: To be documented Type: Bug Package: PDO related Operating System: Windows NT PBMA-WB2 5.2 build 37 PHP Version: 5.1.6 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/. Thank you for the report, and for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2010-12-17 21:07:48] [email protected] . ------------------------------------------------------------------------ [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] [email protected] 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/[email protected]/msg40731.html http://www.mail-archive.com/[email protected]/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? ------------------------------------------------------------------------ [2010-02-11 15:40:43] philipp at servicemail24 dot de php 5.3.2 dotdeb still suffers from this problem. does this fix help? "Possible fix: remove "case SQLTEXT" from ext/pdo_dblib/dblib_stmt.c:execute and let it fall though to default." ------------------------------------------------------------------------ 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
