From: tsedeke at feigenblatt dot de
Operating system: Suse Enterprise Server 9
PHP version: 5.2.3
PHP Bug Type: PDO related
Bug description: Problem accessing Oracle ROWID with PDO
Description:
------------
Getting error accessing the oracle rowid in a PDO select statement.
The NLS_LANG is set to AMERICAN_AMERICA.AL32UTF8 same as the database.
I also restartet the Apache2.2 with the php as module, to be sure it take
the right parameters.
Reproduce code:
---------------
$db_username = "elements";
$db_password = "elements";
$db = "oci:dbname=XE;charset=AL32UTF8";
$conn = new PDO($db,$db_username,$db_password);
$stmt = $conn->prepare("SELECT rowid,t1,t2 FROM test");
$stmt->execute();
while ($row = $stmt->fetch()) {
print_r($row);
}
Expected result:
----------------
Array ( [ROWID] => AAADVUAAEAAAAFMAAA [0] => AAADVUAAEAAAAFMAAA [T1] =>
test1 [1] => test1 [T2] => First test [2] => First test )
Actual result:
--------------
Warning: PDOStatement::fetch() [function.PDOStatement-fetch]: column 0
data was too large for buffer and was truncated to fit it
--
Edit bug report at http://bugs.php.net/?id=41996&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=41996&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=41996&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=41996&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=41996&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=41996&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=41996&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=41996&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=41996&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=41996&r=support
Expected behavior: http://bugs.php.net/fix.php?id=41996&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=41996&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=41996&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=41996&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=41996&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=41996&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=41996&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=41996&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=41996&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=41996&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=41996&r=mysqlcfg
