+ 6
can a table have images in it ?
23 Answers
+ 7
Yes, table can contain images. If the data type of the column is Blob in the relational database.
+ 3
Yes, it can but is not recommendable. The best option is to move the image to the server and just save the path
+ 2
Yes,
If you can store the image as Binary data.
You will need to keep track of the format just store the extention as well so the end machine that displays it knows what it is.
The other option is to convert the image to a base64 string and store that, LONGBLOB/LONGTEXT would be required as the string can be quite large. base64 images contain the image type so you just need to output the data and let the end machine handle it. HTML for example you just place the data in the src tag and the browser will handle the rest for you.
+ 1
it's better to store the actual image files in a folder on the server and store a link to a specific image on that folder in the table column.
0
Yeah
0
yes ,
if u want to store image on local db thn it will consist only your image path by using varchar(max)
and
if u want to store image ,audio, pdf file in database thn u have to use BloB
0
Yes, of course. A table can have images by the use of BLOB datatype
0
Yes the table can contain images
0
yes, we can store images in tables
0
Yes, we can. But we have to convert image into binary using blob
0
so many answers in this question...
0
yes.....by using 'bolb' data type at the time of creating table.
or you can modify your existing table by using 'alter' command
0
yes u can use images in tables.. use blob for that. :)
0
what if u want to store data along with images also..you are correct.We are of dynamic nature..So various db provide feature that we can store data as well as images in a table.:-)
0
kya pata
0
yes by using blob
0
you can do so by using blog date type
0
varbinary(max) in SQL SERVER world
0
Blob tell me the examples????
0
under blob data type, yes; see the SQL data types segment for more info
Often have questions like this?
Learn more efficiently, for free:
