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
