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:

 

base64_01

 

 

Running the same query produces this result:

 

base64_02

 

 

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

 

base64_03

 

 

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

 

base64_04