ID: 34630 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Assigned +Status: Closed Bug Type: Feature/Change Request Operating System: * PHP Version: 5CVS-2005-09-24 (cvs) Assigned To: wez
Previous Comments: ------------------------------------------------------------------------ [2005-09-24 20:34:02] [EMAIL PROTECTED] Description: ------------ Quoting a reporting I received via email: I'm trying to use PDO abstraction layer (version 1.0RC1), but I'm having serious problems with LOB support in Oracle and Postgres (the only I've tried). Reproduce code: --------------- <?php /* Connect to an ODBC database using driver invocation */ $dsn = 'pgsql:host=192.168.0.4 port=5432 dbname=isodb_fresz'; $path = "test.jpg"; $dbh = new PDO($dsn, "isodb_user", "isodb_user"); $sql=" insert into iso_dane_binarne (db_dane_binarne_id, db_dane) values(1, ?);"; $content = fopen($path, "rb"); print_r($content); $stmt = $dbh->prepare($sql); print_r(PDO_PARAM_LOB); $stmt->bindParam( 1, $content, PDO_PARAM_LOB); $stmt->execute(); ?> Expected result: ---------------- The image content in the database Actual result: -------------- This inserts something like "Resource id 3#" string into db_dane (bytea type) column. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=34630&edit=1