FAQ
Edit report at https://bugs.php.net/bug.php?id=68326&edit=1

  ID: 68326
  Updated by: sixd@php.net
  Reported by: contact at greg dot md
  Summary: Data from NCLOB column is not returned from PDO_OCI
                      Statement
  Status: Open
-Type: Bug
+Type: Feature/Change Request
  Package: PDO OCI
  Operating System: Mac OS X
  PHP Version: 5.4.34
  Block user comment: N
  Private report: N

  New Comment:

This is "expected" since support for NCLOB or NVARCHAR has not been implemented in PDO_OCI (or to the OCI8 extension).

From http://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG180 :

"Oracle recommends using SQL CHAR, VARCHAR2, and CLOB data types in
AL32UTF8 database to store Unicode character data. Use of SQL NCHAR,
NVARCHAR2, and NCLOB should be considered only if you must use a
database whose database character set is not AL32UTF8."


Previous Comments:
------------------------------------------------------------------------
[2014-10-29 19:30:36] requinix@php.net

Related To: Bug #68327

------------------------------------------------------------------------
[2014-10-29 19:23:21] contact at greg dot md

Description:
------------
I have compiled last sources from https://github.com/php/php-src/tree/master/ext/pdo_oci.

Data from NCLOB type is not returned in the row. From CLOB or NVARCHAR2 is all ok.

Test script:
---------------
$options = array(
     PDO::ATTR_STRINGIFY_FETCHES => true,
);

$dbh = new PDO('dns', 'username', 'password', $options);

$stmt = $dbh->query('select NCLOB_COLUMN from TABLE');

$row = $stmt->fetch(PDO::FETCH_ASSOC);

var_dump($row);




------------------------------------------------------------------------

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 3 | next ›
Discussion Overview
groupphp-bugs @
categoriesphp
postedOct 29, '14 at 7:23p
activeOct 30, '14 at 11:22a
posts3
users2
websitephp.net

2 users in discussion

Contact at greg dot md: 2 posts Sixd: 1 post

People

Translate

site design / logo © 2019 Grokbase