on 08-05-2014 6:33 PM
Hi All,
I am trying to load data from BLOB data from database and save the image file.
SQL to insert data:
INSERT INTO BLOBTest (BLOBName, BLOBData)
SELECT 'First test file', BulkColumn FROM OPENROWSET(Bulk 'C:\Inbound\logo.jpg', SINGLE_BLOB) AS BLOB
I am using the following 'SELECT top 1 BLOBData from BLOBTest' to get the data and setting the value to 'Image Saver' action. The image file is saved to the specified path, but the image is not opening.
I get "Image is damaged, corrupted or is too large message. The file is around 40 KB."
Am i missing something.
Any help would be highly appreciated.
MII Version: 14.0 SP 3
Thanks,
I'd avoid saving images in the DB. The binary formats can return characters which need to be escaped while processing them via XML file transfers. Some control characters, are not even allowed in an XML format. You can save images in the NetWeaver web-space, and put only the link to them in the database. You don't need to publish the images right away, but you can easily use them from there.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
10 | |
5 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.