Exporting base64 encoded data

Top  Previous  Next

If you store base64 encoded data in your memo fields, SQL Image Viewer can decode the data and export the encoded files.  SQL Image Viewer can identify base64-encoded data of all the image and binary types it supports.


When your result set includes a memo-type field, SQL Image Viewer automatically tries to identify if the field contains base64 encoded data.  For e.g. this is the result returned by Management Studio when displaying a base64-encoded PDF file:





Running the same query produces this result:





When you want to export the base64-encoded data, ensure that the memo field is selected for export:





And that the Extract base64-encoded values from memo fields option is selected: