Image column export (into XML)

[xsd]

Dear all,

I have a situation; I have a SQL Server database, and in that there is a table where I am storing image into a field (varbinary)

When I setting up a report (in my case Fast-Report) directly using SQL Server database, the image column appears okay.

My question is: when I trying to export the same with image column in it on to a XML file, and try to use that as my datasource the image is not showing; I presume while exporting the image data is being reformatted; correct me if I am wrong.

What is the fix to make this export work good for an image column;

TIA

[sorin_ristache]

Hello,

The VARBINARY data is mapped to the JDBC type LONGVARBINARY which Oxygen will encode with BASE 64 to a text string. An XML document cannot contain binary data so a binary value must be converted to a text string before saving it to an XML document. You can get the original image by applying a BASE 64 decoder to the string value which Oxygen writes to the XML file.


Regards,
Sorin