0

Is it better to save a image path as (varchar) in a database or save it as blob/varbinary. The image will appear on front end and I will be using asp classic to implement that.

user2038607
  • 27
  • 5
  • Each option has pros and cons, which renders the question too broad. I suggest you research the subject and post more specific questions. – Fernando Correia Jul 08 '14 at 17:17

1 Answers1

2

Generally speaking I find that it is easier to save the image path in the database. This makes the database more portable and I find that it is easier to control access to the data.

There is a discussion here that gets further in depth. They come to the same conclusion that I do. File paths are generally better.

Community
  • 1
  • 1
abalos
  • 1,301
  • 7
  • 12
  • Don't agree, but then again the question is [primary opinion based](http://stackoverflow.com/help/dont-ask) and not a good fit for this site so this will happen. – user692942 Jul 08 '14 at 09:49