hello everyone.
i m using XSLT version 1.0
i m picking data of table in XML which contains a column of image data type.
when i converted this XML document to other using XSLT binary data is written like string and when i tried to store this data into table it returns error cannot convert string to binary???

can we convert string to binary in XSLT

Regards
navi

XML only handles character data. Perhaps you need to convert the character data to binary as a postprocessing phase after the XSLT transformation.

Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer's Reference

XML as it stands cannot store binary data, so that binary data must be being converted into a string to be stored in your XML.

You will therefore have to convert it back to binary format when you are trying to insert it into the database.

As XSLT cannot by itself insert things into databases you must be using some other technology, which will probably be the part that does that conversion.

/- Sam Judson : Wrox Technical Editor -/

Actually i have written XML file for table which contains binary data.
when it is converted into xml a string of binary data written.

Is there any way to convert this string data back into binary while converting into another XML through XSLT.

We've already said, XML cannot hold binary data - therefore the answer is no.



/- Sam Judson : Wrox Technical Editor -/

If you want help, you are going to have to give a much more detailed explanation of what you are doing.

Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer's Reference