ID: 25118
Comment by: jerome dot dury at cegedim dot fr
Reported By: php at jschreiber dot com
Status: Verified
Bug Type: Feature/Change Request
Operating System: GNU/Linux (Gentoo)
PHP Version: 4.3.2
New Comment:
Hello,
I don't think this is really not useful, because we're trying to build
a php script to insert blobs in a DB2 database. Our solution was pretty
robust : it was to re-use some php objects and their relative methods
that we implement in our php web site, in our back-office
procedures...
Because of this bug we are forced to rewrite our procedures with
perl-dbi or visual basic, which provides blobs insertions.
Are you planning to fix this bug ? Or do you leave it like this ?
Thanks
Jérome
Previous Comments:
------------------------------------------------------------------------
[2003-10-22 19:46:59] kalowsky@php.net
Marking this as a verified bug, in the sense that I know it exists.
BLOB support in the ODBC system as it stands is relativly, umm, not
useful. I haven't a good solution to this right now though.
------------------------------------------------------------------------
[2003-09-08 19:09:47] php at jschreiber dot com
I looked at my last trace one more time and saw that
SQLBindParameter( hStmt=1:1, iPar=1,
fParamType=SQL_PARAM_INPUT, fCType=SQL_C_CHAR,
fSQLType=SQL_BLOB, cbColDef=1048576, ibScale=0,
rgbValue=&0000000a, cbValueM
ax=0, pcbValue=&0820563c )
---> Time elapsed - +6.810000E-004 seconds
is being called with fCType=SQL_C_CHAR instead of
SQL_BINARY. So I applied a part of Clara Lius patch to the
code and changed the line containg SQL_LEN_DATA_AT_EXEC as
described in my last comment. Now my "blobtest" script
runs fine!!
But the problem seems not to be totally solved - the
odbc-test that comes with php seems to "hang" on some
statements--sometimes it works, sometimes not...
Anyway, I think that was a step in the right direction, so
here is my patch:
http://www.jschreiber.com/php/blobtest/blob-patch.txt
Jan
------------------------------------------------------------------------
[2003-08-28 05:02:05] php at jschreiber dot com
Sorry, guys...! It still doesn't work. I tried it with my "blobtest"
(http://www.jschreiber.com/php/blobtest/). the insert statement
gets executed, but the blob only contains an empty value (x'').
I uploaded a new db2 trace to
http://www.jschreiber.com/php/blobtest/db2trace_new.txt
I hope that helps you!! Again, thank you for trying to fix that. Jan
------------------------------------------------------------------------
[2003-08-17 13:17:30] php at jschreiber dot com
Description:
------------
I have a problem concerning BLOB fields and DB/2 V8.1.2.
When I try to store a file with odbc_prepare() and
odbc_execute($stmt, $params) no error code is returned, but the
BLOB contains an empty value ("x''", not a NULL value).
I had this bug since I upgraded from DB/2 7.1 to DB/2 8.1 (and
DB/2 8.1.2 as well).
It's not a programming error--all script were working with DB/2
7.1. It even occurs with the odbc-test included in tests/ directory
of the php source distribution.
I tried all tricks mentioned at
http://www7b.software.ibm.com/dmdd/library/techarticle/0301liu/0301liu.html
but without success.
Reproduce code:
---------------
odbc-t5.php from the tests/ directory of the php source distribution.
Expected result:
----------------
Actual result:
--------------
This is the output:
--- snip ---
ODBC Test 5 - Blobs
Connecting to test as db2inst1 - OK
Dropping table "php_test" - OK
Creating table "php_test": - OK
Table Info:
Name Type Length
ID CHAR 32
GIF BLOB 100000
Inserting data: /tmp/phpnyprAM - - - OK
--- snap ---
It looks like everythings works fine, but the the database contains
just "image1" and "x''".
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=25118&edit=1