ID: 25118 Updated by: [EMAIL PROTECTED] Reported By: php at jschreiber dot com Status: Verified Bug Type: Feature/Change Request Operating System: GNU/Linux (Gentoo) PHP Version: 4.3.4 New Comment:
Unfortunately the type SQL_BLOB only exists on DB2 and as such makes this patch pretty useless for the rest of the ODBC users. Previous Comments: ------------------------------------------------------------------------ [2004-03-06 14:00:26] php at jschreiber dot com I think I've finally fixed this bug. Here is my patch: http://www.jschreiber.com/php/blobtest/patch.txt The patch worked with PHP 4.3.x and IBM DB/2 8.1 Fixpack 3 and 4. It has been tested using Linux and Solaris. Apply this patch with cd /path/to/source/php-4.3.4/ext/odbc patch -p1 < /path/to/patch/patch.txt Hope this helps somebody! Regards, Jan ------------------------------------------------------------------------ [2004-02-25 12:55:29] jerome dot dury at cegedim dot fr 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 ------------------------------------------------------------------------ [2003-10-22 19:46:59] [EMAIL PROTECTED] 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 ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/25118 -- Edit this bug report at http://bugs.php.net/?id=25118&edit=1
