ID: 38805 Comment by: kristaps at kraksti dot lv Reported By: gkrajci at arescorporation dot com Status: Assigned Bug Type: PDO related Operating System: Windows NT PBMA-WB2 5.2 build 37 PHP Version: 5.1.6 Assigned To: wez New Comment:
Hello! Have you tried $pdo->query('SET TEXTSIZE {number} '); Where number is text size (in bytes). Max number is 2 GB in bytes. Previous Comments: ------------------------------------------------------------------------ [2008-06-20 13:39:10] mcleod at spaceweb dot nl Also on: OS: Windows XP Pro PHP version: 5.2.5 MSSQL server 2005 It worries me that it affects Zend_Db. I experienced it using PDO directly. ------------------------------------------------------------------------ [2008-06-19 07:01:26] Phil dot H at gmx dot net please fix that bug, this is also a problem if you want to use zend_db or something like that! This makes the whole zend_db classes useless! ------------------------------------------------------------------------ [2008-06-18 12:04:35] me at opensol dot com I can confirm this bug in php 5.2.5 This is a heavy bug, please fix this soon! A setting like mssql.textlimit = 2147483647 mssql.textsize = 2147483647 would be great! ------------------------------------------------------------------------ [2008-03-27 08:25:53] andrew-law at yandex dot ru It's a pity php developers don't hear their colleagues. This is a critical bug and it hasn't fixed yet. ------------------------------------------------------------------------ [2008-01-09 15:14:17] rob at tdd dot org dot uk I have found that it doesn't get truncted with ODBC, however I have found certain stored procedures don't work with ODBC. My solution is to create a DAL class which has a factory method to create a PDO connection based on driver selection. Then during my testing if I find it to work in one and not in another then I switch the database connection over to the one that works. ------------------------------------------------------------------------ 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/38805 -- Edit this bug report at http://bugs.php.net/?id=38805&edit=1