Bug #69553 [Opn->Fbk]: SELECT VARCHAR >255 return empty
| From: | cmb@php.net | 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