php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #38503 Can't load UTF-8 CLOBS
Submitted: 2006-08-18 16:26 UTC Modified: 2006-08-26 01:00 UTC
Votes:4
Avg. Score:4.5 ± 0.9
Reproduced:3 of 3 (100.0%)
Same Version:0 (0.0%)
Same OS:1 (33.3%)
From: thomas dot adams at interone dot de Assigned:
Status: No Feedback Package: OCI8 related
PHP Version: 5.1.5 OS: Ubuntu 4.0.3-1
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: thomas dot adams at interone dot de
New email:
PHP Version: OS:

 

 [2006-08-18 16:26 UTC] thomas dot adams at interone dot de
Description:
------------
Versions of PHP newer than 5.1.2
(5.1.3/4/5) failed at loading a CLOB in a UTF-8 Oracle
Database (tested with Oracle 10.2).

There are neither exceptions thrown nor
any other error messages are shown. 

The statement " echo $row[0]->load();" returns simply no
output. Downgrading to version 5.1.2 resolves this, so this might be bug.   

Kind regards
Thomas Adams




Reproduce code:
---------------
$sql='select ID, TEXT from TEST_CLOB'; // where Text is CLOB
$stmt = oci_parse($connection, $sql);
oci_execute($stmt)
    or die ("Unable to execute query\n");
$i=0;
while ( $row = oci_fetch_array($stmt,OCI_NUM) ) {
    echo ($i+1) . "   ". $row[0] ." : ";
    print $row[1]->load();
    print " ... this is " . (is_object($row[1])?" an object ":" not an object ");
    print " ... object is " . (is_a($row[1],'OCI-Lob')?"a OCI-Lob ":"not a OCI-Lob ");
    print " ... class name of object is " . get_class($row[1]);
    print " ... vardump is ";
    var_dump($row);
    print '<br />';
    $i++;
}

Expected result:
----------------
The "print $row[1]->load();" line should return
the actual values from the select statement.

Actual result:
--------------
row[1]->load() returns nothing.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-08-18 20:35 UTC] tony2001@php.net
Please try using this CVS snapshot:

  http://snaps.php.net/php5.2-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5.2-win32-latest.zip


 [2006-08-26 01:00 UTC] 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-09-29 18:48 UTC] peter dot oulman at uponor-usa dot com
We are experiencing the same issue with PHP v. 5.1.6 on the Linux platform. We also confirmed that downgrading to v. 5.1.2 resolved the problem.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Sat Jan 18 17:01:30 2025 UTC