Bug #60994 [Opn->Csd]: PDO_OCI: Reading a multibyte CLOB caps at 8192 characters

Edit report at https://bugs.php.net/bug.php?id=60994&edit=1 ID: 60994 Updated by: ramsey@php.net Reported by: php dot net at boedah dot de Summary: PDO_OCI: Reading a multibyte CLOB caps at 8192 characters -Status: Open +Status: Closed Type: Bug Package: PDO OCI Operating System: OEL 5 / RHEL5 / Win7 PHP Version: Irrelevant -Assigned To: +Assigned To: ramsey Block user comment: N Private report: N New Comment: The fix for this bug has been committed. If you are still experiencing this bug, try to check out latest source from https://github.com/php/php-src and re-test. Thank you for the report, and for helping us make PHP better. See discussion on https://github.com/php/php-src/pull/8018 Previous Comments: ------------------------------------------------------------------------ [2021-11-22 14:41:42] cmb@php.net Related To: Bug #81650 ------------------------------------------------------------------------ [2021-11-22 14:40:48] cmb@php.net The following pull request has been associated: Patch Name: Fix PDO OCI Bug #60994 (Reading a multibyte CLOB caps at 8192 charact… On GitHub: https://github.com/php/php-src/pull/5233 Patch: https://github.com/php/php-src/pull/5233.patch ------------------------------------------------------------------------ [2020-03-04 01:42:07] rstark at us dot ibm dot com I have submitted a PR for this issue https://github.com/php/php-src/pull/5233 ------------------------------------------------------------------------ [2015-10-12 20:25:44] ashnazg@php.net PHPT test for this bug is in PR #1566 (https://github.com/php/php-src/pull/1566) ------------------------------------------------------------------------ [2015-10-09 16:35:39] ashnazg@php.net Comments on my experience with this bug -- http://stackoverflow.com/questions/33026617/pdo-oci-truncates-large-multibyte-clobs I had the same experience using raw OCI, but found a way to work around it by passing a length value to LOB->read() that is larger than the actual CLOB, thus forcing it to read it all in one big read rather than in smaller chunks via a "while !LOB->eof() then LOB->read()" loop. Since PDO OCI already transforms the LOB into a Stream internally before returning it in my row, I have to guess that it is internally doing the same kind of loop, and thus is losing data in the same way. Since I can't see a way in PDO OCI to force the same read-it-all-at-once behavior, I'm stuck. My environments: - PHP 5.5.24 on RHEL6, oci8 v1.4.10 - PHP 5.5.11 on Win7, oci8 v1.4.10 ------------------------------------------------------------------------ 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 https://bugs.php.net/bug.php?id=60994 -- Edit this bug report at https://bugs.php.net/bug.php?id=60994&edit=1