Bug #69553 [Fbk->NoF]: SELECT VARCHAR >255 return empty

From: Date: Sun, 10 May 2015 04:22:18 +0000
Subject: Bug #69553 [Fbk->NoF]: SELECT VARCHAR >255 return empty
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-192611@lists.php.net to get a copy of this message
Edit report at https://bugs.php.net/bug.php?id=69553&edit=1 ID: 69553 Updated by: php-bugs@lists.php.net Reported by: a dot mothe at oenodata dot fr Summary: SELECT VARCHAR >255 return empty -Status: Feedback +Status: No Feedback Type: Bug Package: PDO ODBC Operating System: Windows 7 PHP Version: 5.5.24 Assigned To: cmb Private report: N New Comment: No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Re-Opened". Thank you. Previous Comments: ------------------------------------------------------------------------ [2015-05-01 18:59:57] cmb@php.net Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. I tried the following with Ingres 10.1.0 and PHP 5.6.8, and it worked as expected: $conn = new PDO('odbc:69553'); $conn->exec('drop table foo'); $conn->exec('create table foo (bar varchar(300))'); $bar = str_repeat('*', 280); $conn->exec("insert into foo values ('$bar')"); $stmt = $conn->query('select bar from foo'); print_r($stmt->fetchAll()); ------------------------------------------------------------------------ [2015-04-30 14:24:41] a dot mothe at oenodata dot fr Description: ------------ hello, I Use a Ingres database (9.2) to connect to this database, i use pdo odbc. Since Php 5.5.x and above (5.6.x), when i request database with un simple select, if column is a varchar > 255, i don't have result. No error, no message... With PHP 5.4.x and below, i don't have this problem... if a use a clasical connexion (odbc_do, odbc_fetch_array etc...) with PHP 5.5.x, i don't have this problem. i don't find anything in a doc on PDO-ODBC between 5.4.x and 5.5.x ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=69553&edit=1

« previous php.bugs (#192611) next »