Save As for blob data

(5 posts) (3 voices)

Tags:

  1. serge lorich, Member

    Good day to you!

    I have files stored in my database's BLOBs.
    How can i make table with links or buttons to download BLOBs as files?

  2. myDBR Team, Key Master

    Blob support is now image only. Downloadable blobs require a bit different handling. We can put it in feature request list.

    --
    myDBR Team

  3. Fadi Nofal, Member

    Dear myDBR Support,

    could you please give us a example to display blob images within report

    Regards

  4. myDBR Team, Key Master

    If you have an image as a blob in the database, you can use a columnstyle to define it as a blob and give it optional styles:

    select 'dbr.colstyle', 'image_data, '[width:150px]image';
    
    select image_data
    from blobtest;

    If the image is stored as base64 encoded, you can use it in an IMG tag:

    select id, concat('dbr.html:') as 'image_data'
    from base64;

    --
    myDBR Team

  5. Fadi Nofal, Member

    Thank you for countinous support ...


Reply

You must log in to post.