{"id":283,"date":"2018-05-29T11:58:41","date_gmt":"2018-05-29T11:58:41","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=283"},"modified":"2018-06-01T06:10:54","modified_gmt":"2018-06-01T06:10:54","slug":"exporting-base64-encoded-values-in-your-databases","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2018\/05\/29\/exporting-base64-encoded-values-in-your-databases\/","title":{"rendered":"Exporting base64 encoded values in your databases"},"content":{"rendered":"

We recently had a prospect that had issues exporting her data using SQL Image Viewer<\/a>.\u00a0 She kindly sent a sample<\/a> of the data, and it turned out that it was a base64 encoded string stored in a memo field.<\/p>\n

So we got to work and now, SQL Image Viewer<\/a> can decode base64 encoded data stored in memo fields.\u00a0 It will recognize most image and binary file types.\u00a0 For example, this is the result returned by Management Studio for a query that retrieves a base64 encoded PDF file:<\/p>\n

\"\"<\/p>\n

 <\/p>\n

This is the result returned by the same query in SQL Image Viewer<\/a>:<\/p>\n

\"\"<\/p>\n

 <\/p>\n

You can immediately identify the type of data that’s stored in your database.\u00a0 When you want to export the file, ensure that you select the memo field:<\/p>\n

\"\"<\/p>\n

 <\/p>\n

and also the Extract base64 encoded values in memo fields<\/strong> option:<\/p>\n

\"\"<\/p>\n

 <\/p>\n

For now, SQL Image Viewer<\/a> will not inspect binary blob fields for base64 encoded data, as it wouldn’t make sense to store text values in a binary fields.\u00a0 However, if you do find yourself in such a situation, do drop us a line at support@yohz.com<\/a>.<\/p>\n

Download<\/a> a trial of SQL Image Viewer now, or buy<\/a> a license from only USD 45.<\/p>\n

<\/fb:like><\/div>
<\/div><\/div>","protected":false},"excerpt":{"rendered":"

We recently had a prospect that had issues exporting her data using SQL Image Viewer.\u00a0 She kindly sent a sample of the data, and it turned out that it was a base64 encoded string stored in a memo field. So we got to work and now, SQL Image Viewer can decode base64 encoded data stored […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5,11],"tags":[42,7,12],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/283"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=283"}],"version-history":[{"count":2,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/283\/revisions"}],"predecessor-version":[{"id":289,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/283\/revisions\/289"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}