Re: DB2 and php serialized data

Gerard Samuel wrote:

Most likely its not a PHP issue, but looking to see if anyone has run into this. I've inserted a serialized string, into a CLOB column. Trying to retrieve the column returns no results. If anyone has any DB2 experience, I'd be grateful if I can bounce a few questions to you offlist. Thanks for any advice/tips you may provide...

I did a few more tests last night, and the problem isn't with serialized data. Im currently testing to see if a result contains returned data by issuing odbc_num_rows() The wierd thing is that if I try to select a CLOB column (this is what Im using at the moment, but I believe it applies to all LOBs), odbc_num_rows() would return -1 If I do not select a CLOB (ie INTEGER, VARCHAR this is what Im currently testing with) column, odbc_num_rows() would return the correct number of rows. I've read about odbc_num_rows() returning -1 for some databases, but that statement alludes me to believe that it either works, or doesn't work for a database. Not whether it will work for some sql conditions. So Im not sure if this is a bug or not. Im currently testing with PHP 4.3.3R2, IBM DB2 8.1 Personal Edition on win2k/IIS 5 If what Ive noticed is the expected behaviour, please let me know so I'll know whether or not to fill out a bug report... If anyone wants more information, please let me know... Thanks