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

From: Date: Fri, 01 May 2015 18:59:58 +0000
Subject: Bug #69553 [Opn->Fbk]: SELECT VARCHAR >255 return empty
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-192443@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: cmb@php.net Reported by: a dot mothe at oenodata dot fr Summary: SELECT VARCHAR >255 return empty -Status: Open +Status: Feedback Type: Bug Package: PDO ODBC Operating System: Windows 7 PHP Version: 5.5.24 -Assigned To: +Assigned To: cmb Block user comment: N Private report: N New Comment: 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()); Previous Comments: ------------------------------------------------------------------------ [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 (#192443) next »