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

From: thomas dot adams at interone dot de Operating system: Ubuntu 4.0.3-1 PHP version: 5.1.5 PHP Bug Type: OCI8 related Bug description: Can't load UTF-8 CLOBS 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 bug report at http://bugs.php.net/?id=38503&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=38503&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=38503&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=38503&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=38503&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=38503&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=38503&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=38503&r=needscript Try newer version: http://bugs.php.net/fix.php?id=38503&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=38503&r=support Expected behavior: http://bugs.php.net/fix.php?id=38503&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=38503&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=38503&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=38503&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38503&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=38503&r=dst IIS Stability: http://bugs.php.net/fix.php?id=38503&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=38503&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=38503&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=38503&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=38503&r=mysqlcfg