|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPdoOciClobReadError-test-with-more-debug-output (last revision 2012-02-06 16:19 UTC by php dot net at boedah dot de)Pull Requests
Pull requests:
HistoryAllCommentsChangesGit/SVN commits
[2012-02-06 16:20 UTC] php dot net at boedah dot de
[2012-02-07 02:42 UTC] aharvey@php.net
-Package: PDO related
+Package: Oracle related
[2012-06-26 22:37 UTC] sixd@php.net
-Package: Oracle related
+Package: PDO related
[2014-01-01 12:40 UTC] felipe@php.net
-Package: PDO related
+Package: PDO OCI
[2015-10-09 16:35 UTC] ashnazg@php.net
[2015-10-12 20:25 UTC] ashnazg@php.net
[2020-03-04 01:42 UTC] rstark at us dot ibm dot com
[2021-11-22 14:40 UTC] cmb@php.net
[2023-02-07 15:37 UTC] ramsey@php.net
-Status: Open
+Status: Closed
-Assigned To:
+Assigned To: ramsey
[2023-02-07 15:37 UTC] ramsey@php.net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Thu Oct 30 18:00:02 2025 UTC |
Description: ------------ Inserting large multibyte strings works fine, reading them back in results in only 8192 characters read (=24576 bytes). Even if inserting mixed single-multibyte strings, reading caps at 8192 characters (even though the byte count is far less). Inserting and reading 100000 single bytes work, though. Attached a file with more debug output. == PHP == We are using ZendServer 5.5.0: PHP 5.3.8-ZS5.5.0 (cli) (built: Aug 23 2011 05:20:27) Copyright (c) 1997-2011 The PHP Group Zend Engine v2.3.0, Copyright (c) 1998-2011 Zend Technologies But this bug also is on PHP 5.4.0RC8-dev == Oracle == Oracle XE 10.2.0.1, but also on Enterprise 10.2.0.4.0. Characterset: AL32UTF8 Test table: create table TEST_LOB ( tl_id NUMBER(3), tl_byte_16 VARCHAR2(16 BYTE), tl_char_16 VARCHAR2(16 CHAR), tl_byte_4000 VARCHAR2(4000 BYTE), tl_char_4000 VARCHAR2(4000 CHAR), tl_blob BLOB, tl_clob CLOB, tl_date DATE, tl_number NUMBER ) Test script: --------------- $dsn = 'oci:dbname=(DESCRIPTION=(ADDRESS_LIST=( ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) (CONNECT_DATA=(SID=xe)));charset=AL32UTF8'; $username = 'USER'; $password = 'PW'; $lobTestTablename = 'TEST_LOB'; $id = -1; $clobData = str_repeat('…', 8193); $pdo = new PDO($dsn, $username, $password); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->exec("delete from $lobTestTablename where tl_id < 0"); $pdoStmt = $pdo->prepare("insert into $lobTestTablename (tl_id, tl_clob) values (?, ?)"); $pdoStmt->bindParam(1, $id, PDO::PARAM_INT, null, null); $pdoStmt->bindParam(2, $clobData, PDO::PARAM_STR, strlen($clobData), null); $pdoStmt->execute(); $pdoStmt = $pdo->query("select * from $lobTestTablename where TL_ID = $id"); $row = $pdoStmt->fetch(PDO::FETCH_ASSOC); $dataRead = stream_get_contents($row['TL_CLOB']); printf("values equal: %s\n", var_export($clobData === $dataRead, true)); Expected result: ---------------- values equal: false Actual result: -------------- values equal: true