|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2007-08-23 14:51 UTC] jani@php.net
[2007-09-06 14:22 UTC] rubio at jsc dot com dot ar
[2008-07-21 18:05 UTC] pajoye@php.net
[2016-03-08 01:41 UTC] sixd@php.net
-Package: PDO related
+Package: PDO OCI
|
|||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Nov 30 05:00:01 2025 UTC |
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