I'd like to add an image upload column to my table and have these images stored in the database.
How do I create something like this?
What columns & domains do I have to include, etc.?
Solved
upload image and store it in the database
- Captain
- 96 replies
Best answer by Mark Jongeling
Hi Roy,
Couple of columns are needed, one being the upload column and one being the blob (data column).
In this example,
- company_logo_blob is the upload column and will display the uploaded icon/picture. The value in the database is the name of the file.
- company_logo_blob_data is the varbinary(max) column that will store the varbinary data of the uploaded icon/picture.
- Domain Blob_upload as domain, can be nvarchar(2048)
- Domain Blob_data as varbinary(max)
This topic has been closed for comments
+23Hi Roy,
Couple of columns are needed, one being the upload column and one being the blob (data column).
In this example,
- company_logo_blob is the upload column and will display the uploaded icon/picture. The value in the database is the name of the file.
- company_logo_blob_data is the varbinary(max) column that will store the varbinary data of the uploaded icon/picture.
- Domain Blob_upload as domain, can be nvarchar(2048)
- Domain Blob_data as varbinary(max)
- Captain
- 96 replies
Thanks Mark,
Is there also a way to have a larger image than a small icon? Let's say about 5cm x 5cm?
+23The original dimensions will be kept if possible, otherwise it will get reduced in size. Uploaded pictures won't be enlarged.
"Wake me up before you low-code"
1 person likes this
- Captain
- 96 replies
I see. Setting the Field width (px) and the Field height in positions will do the trick.
1 person likes this
+8- Superhero
- 96 replies
Mark Jongeling wrote:
The original dimensions will be kept if possible, otherwise it will get reduced in size. Uploaded pictures won't be enlarged.
Hi
Can you tell me a bit more about the shrinkage process when reducing the original size? I’ve got this question handed to me since we encountered ‘extremely’ large pictures which significantly reduce performance on the information system.
Can you shed a light on the conditions when it gets reduced, maybe what kind of algorithm you may be using and if I can adjust the conditions when and on what types of upload this can be applied upon? And is this applicable on all the GUI platforms?
Are you referring to size as in file size in bytes? When uploading the original file size is maintained in the database. The preview element will scale the picture according to the aspect ratio's but this will not impact the actual file size on the database.
1 person likes this
+8- Superhero
- 96 replies
Erwin Ekkel wrote:
Are you referring to size as in file size in bytes? When uploading the original file size is maintained in the database. The preview element will scale the picture according to the aspect ratio's but this will not impact the actual file size on the database.
Thanks - I was indeed referring to the actual size in bytes - this is something we’ve noticed we would like to get resized for certain binaries (i.e. pictures and videos). Which as for example is something that whatsapp,facebook,imgur,google does/can do when uploading a fresh photo or video you’ve taken/shot.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.