php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #40975 PDO: Mode for autoloading of LOBs
Submitted: 2007-04-02 11:12 UTC Modified: 2007-04-17 06:28 UTC
From: spatar at mail dot nnov dot ru Assigned:
Status: Closed Package: Feature/Change Request
PHP Version: 5.2.1 OS: All
Private report: No CVE-ID: None
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: spatar at mail dot nnov dot ru
New email:
PHP Version: OS:

 

 [2007-04-02 11:12 UTC] spatar at mail dot nnov dot ru
Description:
------------
Many applications use CLOBs for storing not very big data, but more than varchar2 can store. For such applications it isn't handy to deal with streams.

Also sometimes it's impossible for table with CLOB column to do $stmt->fetchAll(), because the number of simultaneously opened LOBs is limited in a database (300 in Oracle by default) and only one correct way is to do $stmt->fetch() in a loop and check if a column is resource.

I request to add a fetching mode when PDO loads every LOB in a cursor automatically in its C++ code. PHP code will look like this:

$result = $stmt->fetchAll(PDO::FETCH_ASSOC | PDO::LOB_AUTO_LOAD);



Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2007-04-17 06:28 UTC] spatar at mail dot nnov dot ru
I found that this feature is already implemented but not documented:

$dbh->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Wed Jul 30 17:00:02 2025 UTC