From: masui at emplex dot co dot jp
Operating system: linux
PHP version: 5.2.0RC4
PHP Bug Type: OCI8 related
Bug description: OCI-Lob->loa return broken character
Description:
------------
OCI-Lob->load returns broken character or nothing in php 5.2.0RC4.
It is occurred in 64bit linux, in 32bit linux OCI-Lob->read returns
correct multibyte string.
My Oracle database is R10.2.0.2.0, charset is AL32UTF8.
Downgrading to php 5.2.0RC1, it works correct, so this might be bug.
Best regards
Hideaki Masui
Reproduce code:
---------------
$conn = oci_connect('scot', 'tiger', 'xxx');
if (!$conn) exit;
$query = 'SELECT LOBDATA FROM LOBTEST';
$stid = oci_parse($conn, $query);
if (!$stid) exit;
$r = oci_execute($stid, OCI_DEFAULT);
if (!$r) exit;
while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) {
echo $row['LOBDATA']->load() ."\n";
}
oci_close($conn);
Expected result:
----------------
The "echo $row['LOBDATA']->load();" line should return
the actual mulitibyte string from the select statement.
Actual result:
--------------
$row['LOBDATA']->load() returns broken character or nothing.
--
Edit bug report at http://bugs.php.net/?id=38972&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=38972&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=38972&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=38972&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=38972&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=38972&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=38972&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=38972&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=38972&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=38972&r=support
Expected behavior: http://bugs.php.net/fix.php?id=38972&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=38972&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=38972&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=38972&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38972&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=38972&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=38972&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=38972&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=38972&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=38972&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=38972&r=mysqlcfg
