title: How do I store the location of an image in a database?
body: <p>I have a list of colors, with textures that I want to show to particular users, so I need to load the image of the colors that a particular user has, the color's information is contained in a ObjecDTO and one of the properties is its image path. My question is how should I store the image path in the database, are there any special rules, for example since the database and the image file are on the same server should I store a complete file URL, or a relative url, what characters should I escape etcetera, or are there better approaches than mine?</p>
  
  <p>I've searched the web but mostly point to storing BLOBs in the database, which I've found  to be a bad practice.</p>
  
  <p>Any guidance is really appreciated.</p>
  
  <p>regards Tristian.</p>