Sql Server Picture Issue

Hello Everyone,
I hope everyone is doing well.
i am doing a project storing and getting data from sql server, everything is working well except for the picture. To store picture in sql server it needs to be converted in Varbinary(8000). Now, I need to fetch it back to show in my bubble app. But Nothing is working. I have used bubble’s encoeded into base64 as well but nothing is working.
I am uploading picture from bubble through picture uploader.

Any Suggestions ?

Thank You.

Here are some steps and tips to help you resolve this issue:

  1. Storing the Image in SQL Server:
  • Ensure your image is correctly converted to a VARBINARY(MAX) before storing it in the SQL Server.
  • You can use a SQL query like this

INSERT INTO YourTable (ImageColumn) VALUES (CAST(@YourImage AS VARBINARY(MAX)))

Image is stored in sql server and it’s fine . It’s working in this way, Take picture from sql server and store it in bubble database then show it… This way is working. But i don’t want to store image in bubble. I Just want it to show directly from sql server. I am looking for a solution to do that

This topic was automatically closed after 70 days. New replies are no longer allowed.