ID: 38805 Comment by: ritch at bugsoftware dot co dot uk 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:
I'm also suffering this problem after changing my database connection type to PDO. I'm running PHP 5.1.2 on Windows server 2003 with MSSQL 2005. In the old mssql ext. you had to specificaly tell the configure it in php.ini to bring back larger text fields: ; Valid range 0 - 2147483647. Default = 4096. mssql.textlimit = 2147483647 ; Valid range 0 - 2147483647. Default = 4096. mssql.textsize = 2147483647 I have not found the same for the new PDO extension - so I'm assuming this has some thing to do with the problem. (My text fields are also truncated to 4096) Help with this issue would be greatley appreciated. Previous Comments: ------------------------------------------------------------------------ [2006-09-14 11:47:26] gkrajci at arescorporation dot com Microsoft SQL Server connections PHP.INI --------------------------- extension=php_pdo.dll extension=php_pdo_mssql.dll extension=php_pdo_mysql.dll PDO PDO support enabled PDO drivers mssql, mysql pdo_mssql PDO Driver for MSSQL DB-lib enabled Flavour MSSQL_70 pdo_mysql PDO Driver for MySQL, client library version 5.0.22 ------------------------------------------------------------------------ [2006-09-13 15:45:31] [EMAIL PROTECTED] I assume you're using ODBC? ------------------------------------------------------------------------ [2006-09-13 15:40:37] [EMAIL PROTECTED] what PDO driver are you using? ------------------------------------------------------------------------ [2006-09-13 13:06:35] gkrajci at arescorporation dot com Description: ------------ When using PDO to retrieve text from a SQL Server text data type field the text is truncated when I display it on a Web page PDO Transcript length = 4096 (truncated) PEAR Transcript length = 6139(full text) Using SQL Server 2000 Reproduce code: --------------- $sql = "SELECT title AS VideoTitle, transcript_text AS TranscriptText FROM video WHERE video_id = 324"; $dbh = new PDO($pdo_dsn, $db_user, $db_password); $transcript_q = $dbh->query($sql); $transcript_rs = $transcript_q->fetch(); $pear_dsn = "$db_type://$db_user:[EMAIL PROTECTED]/$db_name"; require_once( 'DB.php' ); $db = DB::connect( $pear_dsn, true ); if ( DB::isError($db) ) die( $db->getMessage() ); $res = $db->query($sql); $row = $res->fetchRow(); Expected result: ---------------- The text in TranscriptText to be the text and the same length. Actual result: -------------- See Description for this bug report. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=38805&edit=1