xml base64 binary data type problem

• nsrao

  SSC-Addicted

  Points: 431

  More actions

  June 6, 2005 at 12:35 am

  #67530

  Hi,

     I have an xml file with an element of base 64 binary type data.. i need to import the same into image type column in my sqlserver table (vice versa was done while exporting from sqlserver table to xml ).. Can any one tell me how can i do this...

   

  Regards,

  Narasimha Rao Chandramouli

   

   

• DanKennedy

  Hall of Fame

  Points: 3736

  More actions

  June 7, 2005 at 2:35 am

  #563419

  This link may help which states you can bulk load or use an updategram to insert the base64 encoded data by using a schema and specifying the datatype as bin.base64.

  There is also a custom code example in C++, although it should be even easier to do a .NET one.

  http://www.sqlxml.org/faqs.aspx?faq=51

  ---

  Dan
  www.firstcs.co.uk