Varbinary into XML

• ib-321506

  Valued Member

  Points: 68

  More actions

  July 3, 2007 at 1:17 pm

  #124895

  Hello,

  I have a column with type 'varbinary' containing signatures.  What is the easiest way to store the value of this field in an XML file so I can pass on that XML to another group (which doesn't have MSSQL Server).

  Thank you

• bledu

  SSChampion

  Points: 12335

  More actions

  July 6, 2007 at 8:29 am

  #717711

  did u get this one resolved?

  ---

  Everything you can imagine is real.
  

• Mark Harr

  SSCrazy Eights

  Points: 9921

  More actions

  July 6, 2007 at 10:49 am

  #717749

  Easiest way for you is to use FOR XML RAW and BINARY BASE64.  Example is from BOL:

  USE AdventureWorksGOSELECT ProductPhotoID, ThumbNailPhotoFROM Production.ProductPhotoWHERE ProductPhotoID=1FOR XML RAW, BINARY BASE64 ;GO

  produces

  <row ProductModelID="1" ThumbNailPhoto="base64 encoded binary data"/>

  Of course, it will be up to the destination application to handle to blob data appropriately.

  Hope this helps

  
  
  Mark