We have been using clob column in oracle and use resultset_getstring and it works well .
Regards,
Abhay Gupta
On 01-Feb-2014, at 5:43 am, Jan-Henrik Haukeland hauk@tildeslash.com wrote:
ResultSet_getBlob or ResultSet_getString should be interchangeable on a blob or text column. Though of course, if the blob column contains binary data only ResultSet_getBlob should be used to get the correct value.
I should say that a problem with using ResultSet_getString on a blob column was just fixed in Oracle and confirmed fixed in version 3.0. So with one datapoint, the above seems to work. If you want us to investigate, we are also more inclined to do so if you can provide a small test program demonstrating the problem. Or argue in detail why the problem must be in libzdb.
Best regards
Jan-Henrik Haukeland
On 31 Jan 2014, at 13:36, Mats Christensen matschristensen@gmail.com wrote:
I'm not very familiar with Oracle either but it seems like CLOB is for Oracle what TEXT is for Postgres and MySQL.
There is a function in the dbmail-code called 'db_result_get_blob', it is used for several things, like '_fetch_headers'. HEADERVALUE is a CLOB.on Oracle and TEXT on Postgres.
Perhaps this function should have been used on '_fetch_envelope' too?
It will probably be easiest for me to just use getBlob instead, as for upstream, perhaps it's a good idea to use 'db_result_get_blob' for all TEXT/CLOB-fields if it works?
Thank you very much for the help!
Regards, Mats Christensen
-- To unsubscribe: http://www.tildeslash.com/mailman/listinfo/libzdb-general