Sql Server Picture Issue

umershafiq117 · 2024-07-22T08:40:37.100Z

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.

fizaahmad399 · 2024-07-22T11:17:50.161Z

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

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)))

umershafiq117 · 2024-07-22T13:09:14.667Z

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

system · 2024-09-30T08:41:36.597Z

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