Member Avatar for dragon@dragon64

I would like to create a table in mysql, with one of the fields being images. Can any one tell me what type i should call the field, and also if i have to put in any special commands. thank you

  • 2 Contributors
  • 5 Replies
  • 91 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by nav33n

Recommended Answers

All 5 Replies

Member Avatar for nav33n

Its not a good idea to store images in the table. The time required to fetch an image from the table and displaying it is more (obviously) than displaying the image from the file system. You can save the image in the file system and save its path in the table. That is what most people do. But if you intend to store images in the database, then blob would be the datatype.

Member Avatar for dragon@dragon64

even though the images are small, 104 by 128

Member Avatar for nav33n

Blob it is! (But still, I don't recommend it).

Member Avatar for dragon@dragon64

sorry to pester you again, as i am not that good. So what you are suggesting is that i upload the images into a folder, and then in the table i would just put in the link to the file?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.