Post reply

xml base64 binary data type problem

  • 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

     

     

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply