Edit report at https://bugs.php.net/bug.php?id=25118&edit=1
ID: 25118
Updated by: krakjoe@php.net
Reported by: php at jschreiber dot com
Summary: ODBC: can't store data in blob fields
-Status: Verified
+Status: Closed
Type: Feature/Change Request
Package: ODBC related
Operating System: GNU/Linux (Gentoo)
PHP Version: 4.3.4
-Assigned To:
+Assigned To: krakjoe
Block user comment: N
Private report: N
New Comment:
This would appear to be yet another issue with the ODBC driver.
There are better drivers for ODBC today, and it would seem that everybody is using those, because
these bugs are not generating any interest/conversation and haven't for a decade.
If anyone thinks I'm wrong to close this, please open a PR to improve ODBC.
Previous Comments:
------------------------------------------------------------------------
[2004-03-09 18:16:29] php at jschreiber dot com
Uhm, originally I wanted to give DB2 users the chance to evaluate this patch first. But if you think
that wrapping the modified lines with
#if defined(HAVE_IBMDB2)
#endif
directives will be enough to save poor non-DB2 users from the evil SOL_BLOB, you can take a look at
the updated version of the patch at
http://www.jschreiber.com/php/blobtest/patch.txt
Jan
------------------------------------------------------------------------
[2004-03-09 12:08:04] kalowsky@php.net
Unfortunately the type SQL_BLOB only exists on DB2 and
as such makes this patch pretty useless for the rest of
the ODBC users.
------------------------------------------------------------------------
[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] 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.
------------------------------------------------------------------------
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
https://bugs.php.net/bug.php?id=25118
--
Edit this bug report at https://bugs.php.net/bug.php?id=25118&edit=1