I have a program that I developed that builds an XML file that stores base64binary data from images stored in SQL Server. The XML file along with the schema get transfered, then another program picks them up and uses the SQLXMLBULKLOADL ib to insert the XML data based mapped with a Schema file back into SQL Server.
The problem is that when it imports it into SQL Server, it creates a varbinary(8000) data type instead of varbinary(MAX)...
2 results in 0.0041 seconds.
-
SQL XML Bulk Load varbinary(8000) to varbinary(MAX)
-
XML base64Binary
Hi,
I have a web service which stores an uploaded image into SQL server, thus
there are a few things need to do:
1. Convert image to base64Binary.
2. Call web service and embed image as base64Binary in XML string.
3. Web service save image binary into SQL.
Where can i find the samples. Is there any other way to implement it.
Thanks in advance...
