ID: 34211
User updated by: kurtb149 at yahoo dot com
Reported By: kurtb149 at yahoo dot com
-Status: No Feedback
+Status: Open
Bug Type: Feature/Change Request
Operating System: Linux
PHP Version: 6CVS-2005-08-22 (CVS)
Assigned To: tony2001
New Comment:
1. Create a table in Oracle that used the "timestamp(0) with local time
zone" type:
SQL> create table ltz_test(aa timestamp(0) with local time zone not
null) ;
2. Insert a row into ltz_test:
SQL> insert into ltz_test values(current_timestamp);
3. Using PDO, read the table:
<?php
$dbh = new PDO('oci:', 'username', 'hello');
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$dbh->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER);
$sth = $dbh->prepare('select aa from ltz_test');
$sth->execute();
$r = $sth->fetch();
print $r[0] . "\n";
?>
The following error is produced:
Warning: PDOStatement::fetch(): column 0 data was too large for buffer
and was truncated to fit it in ltz_test.php on line 7
Previous Comments:
------------------------------------------------------------------------
[2006-04-14 01:00:00] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2006-04-06 07:27:34] [EMAIL PROTECTED]
Thanks for posting the patch again.
Actually I asked you to provide a small piece of PHP code I can use to
test the problem you are trying to fix.
------------------------------------------------------------------------
[2006-04-05 23:32:59] kurtb149 at yahoo dot com
$ cvs diff oci_statement.c
Index: oci_statement.c
===================================================================
RCS file: /repository/php-src/ext/pdo_oci/oci_statement.c,v
retrieving revision 1.20
diff -r1.20 oci_statement.c
420a421,424
> #ifdef SQLT_TIMESTAMP_LTZ
> || dtype == SQLT_TIMESTAMP_LTZ
> #endif
>
------------------------------------------------------------------------
[2006-04-04 09:52:45] [EMAIL PROTECTED]
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 possible, make the script source available online and provide
an URL to it here. Try to avoid embedding huge scripts into the report.
------------------------------------------------------------------------
[2005-08-22 23:28:18] [EMAIL PROTECTED]
reclassified
------------------------------------------------------------------------
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/34211
--
Edit this bug report at http://bugs.php.net/?id=34211&edit=1
