BLOB or CLOB DataType

, ,
1

If one column is CLOB or BLOB datatype, for example, gif image or word doc,
can XNODE support CLOB or BLOB datatype?
if yes, how to query?

thanks,

Best Regards,

Michael

2

Hi Michael,

I think the answer to the question is no, Blobs/clobs are not supported via X-Node. The problem I forsee is that when a blob is returned from the SQL store it is in it’s raw form. The question then is how to embed this into an XML document? Without some form of encoding (e.g. base64) the binary object would invalidate the xml most likely. Therefore it is well advised to handle XML and non XML separately.

Stuart