can a table have images in it ?

Answer 1

Yes, table can contain images. If the data type of the column is Blob in the relational database.

Answer 2

Yes, it can but is not recommendable. The best option is to move the image to the server and just save the path

Answer 3

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.

Answer 4

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.

Answer 5

Yeah

Answer 6

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

Answer 7

Yes, of course. A table can have images by the use of BLOB datatype

Answer 8

Yes the table can contain images

Answer 9

yes, we can store images in tables

Answer 10

Yes, we can. But we have to convert image into binary using blob

Answer 11

so many answers in this question...

Answer 12

yes.....by using 'bolb' data type at the time of creating table.
or you can modify your existing table by using 'alter' command

Answer 13

yes u can use images in tables.. use blob for that. :)

Answer 14

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

Answer 15

kya pata

Answer 16

yes by using blob

Answer 17

you can do so by using blog date type

Answer 18

varbinary(max) in SQL SERVER world

Answer 19

Blob tell me the examples????

Answer 20

under blob data type, yes; see the SQL data types segment for more info