ID: 25118
Updated by: [EMAIL PROTECTED]
Reported By: php at jschreiber dot com
-Status: Open
+Status: Feedback
Bug Type: ODBC related
Operating System: GNU/Linux (Gentoo)
PHP Version: 4.3.2
New Comment:
I don't see how this is a PHP problem if the problem arose when you
upgraded databases. If you have tried what was in that article, why
not share the altered code, as that would help debug what has gone
wrong.
Previous Comments:
------------------------------------------------------------------------
[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
