#38503 [Com]: Can't load UTF-8 CLOBS

ID: 38503 Comment by: peter dot oulman at uponor-usa dot com Reported By: thomas dot adams at interone dot de Status: No Feedback Bug Type: OCI8 related Operating System: Ubuntu 4.0.3-1 PHP Version: 5.1.5 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [2006-08-26 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-08-18 20:35:13] 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-18 16:26:33] 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. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=38503&edit=1