I have found 2 ways to attempt this but still unsuccessful with blob datatype for 1 of my tables... cannot find way to enter data or retrieve it.
I am using DB2 and PHP using PHP's ODBC support.
I read the client image file using fread(). Then change it to replace " with ' (note: addslashes not used since that is only for mySQL). Then store the variable containing the image into the db using simple insert. This fails. Does someone know the correct procedure??
The other scenario explained to me was to bind the input file to the column using something like orabind() for oracle. BUT what is the function to be called for odbc ??
Also I know there are DB2 stored procedures that do this bind, BUT HOW DO I CALL DB2 Stored Procedures through PHP?????
Thanks in advance.