On 31 Jan 2014, at 11:34, Paul J Stevens paul@nfg.nl wrote:
the Oracle schema is the only one that defines the 'envelope' field as a CLOB. PostgreSQL and MySQL both treat it as a TEXT field. So DBMail uses ResultSet_getString to retrieve the value, not ResultSet_getBlob.
This should be fine. According to the contract, using ResultSet_getString on a blob field is okay, especially if the value is a text type and vice a versa. I do not have Oracle installed either and it is Volodymyr who has worked on this part of libzdb. Volodymyr, do you have any suggestion?
Jan-Henrik