+ 6

can a table have images in it ?

29th Aug 2016, 8:07 PM
Apurvi Sekar
Apurvi Sekar - avatar
23 odpowiedzi
+ 7
Yes, table can contain images. If the data type of the column is Blob in the relational database.
30th Aug 2016, 2:50 AM
Akilan Mc
Akilan Mc - avatar
+ 3
Yes, it can but is not recommendable. The best option is to move the image to the server and just save the path
2nd Sep 2016, 5:38 AM
Gerardo Mérida
Gerardo Mérida - avatar
+ 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.
31st Aug 2016, 12:56 AM
Nathan “Grimston” Pipes
Nathan “Grimston” Pipes - avatar
+ 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.
5th Sep 2016, 12:37 PM
Paco Aguillar
0
Yeah
30th Aug 2016, 3:04 AM
Mohammed Dan
Mohammed Dan - avatar
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
30th Aug 2016, 3:51 AM
divyanshu dwivedi
divyanshu dwivedi - avatar
0
Yes, of course. A table can have images by the use of BLOB datatype
31st Aug 2016, 10:14 AM
sasidharan
0
Yes the table can contain images
1st Sep 2016, 10:09 AM
Rohit Thatavarthi
Rohit Thatavarthi - avatar
0
yes, we can store images in tables
2nd Sep 2016, 4:27 PM
shubhanshu gupta
shubhanshu gupta - avatar
0
Yes, we can. But we have to convert image into binary using blob
3rd Sep 2016, 11:44 AM
Vishal Pawar
0
so many answers in this question...
12th Sep 2016, 5:17 PM
Solo Player Sabin
Solo Player Sabin - avatar
0
yes.....by using 'bolb' data type at the time of creating table. or you can modify your existing table by using 'alter' command
15th Oct 2016, 2:15 PM
Anna K
0
yes u can use images in tables.. use blob for that. :)
21st Nov 2016, 3:48 AM
Arun Bhandari
Arun Bhandari - avatar
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.:-)
16th Dec 2016, 3:17 AM
Sohel
0
kya pata
6th Jan 2017, 7:39 PM
Ganpat patel
Ganpat patel - avatar
0
yes by using blob
26th Jan 2017, 11:57 AM
Aditya Agarwal
Aditya Agarwal - avatar
0
you can do so by using blog date type
27th Jan 2017, 12:39 PM
Abhishek Singhal
Abhishek Singhal - avatar
0
varbinary(max) in SQL SERVER world
31st Jan 2017, 4:10 AM
Ariel Cani
Ariel Cani - avatar
0
Blob tell me the examples????
31st Jan 2017, 6:13 PM
bibhishan biradar
0
under blob data type, yes; see the SQL data types segment for more info
11th Feb 2017, 3:40 PM
Nathan Algren