How to show image from Longblob data type stored in MySQL database?

Stimulsoft Reports.PHP discussion
Post Reply
sidik.romadi
Posts: 2
Joined: Mon Apr 19, 2021 3:26 am

How to show image from Longblob data type stored in MySQL database?

Post by sidik.romadi » Mon Apr 19, 2021 3:45 am

Hello Stimulsoft support,

I want to show image from Longblob data type stored in MySQL v8 database on MRT file by code.

Could you please share sample code/project that solve that issue.

Regards,
Sidik
Lech Kulikowski
Posts: 3939
Joined: Tue Mar 20, 2018 5:34 am

Re: How to show image from Longblob data type stored in MySQL database?

Post by Lech Kulikowski » Mon Apr 19, 2021 7:24 am

Hello,

Unfortunately, Blob fields are not supported.

Thank you.
sidik.romadi
Posts: 2
Joined: Mon Apr 19, 2021 3:26 am

Re: How to show image from Longblob data type stored in MySQL database?

Post by sidik.romadi » Mon Apr 19, 2021 8:13 am

So, what's the alternative?

What if I convert the table that contain the Longblob data type to JSON and then make that as a data source for MRT, can it work?
Lech Kulikowski
Posts: 3939
Joined: Tue Mar 20, 2018 5:34 am

Re: How to show image from Longblob data type stored in MySQL database?

Post by Lech Kulikowski » Tue Apr 20, 2021 8:43 am

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.
#3921
Lech Kulikowski
Posts: 3939
Joined: Tue Mar 20, 2018 5:34 am

Re: How to show image from Longblob data type stored in MySQL database?

Post by Lech Kulikowski » Thu Apr 29, 2021 7:18 am

Hello,

Please check the last release build.

Thank you.
Attachments
Screenshot 2021-04-29 091800.png
Screenshot 2021-04-29 091800.png (451.18 KiB) Viewed 3695 times
Post Reply