title: Saving image urls to database table
body: <p>I am trying to save image urls to a MySQL database table</p>
  
  <p>The column field is long enough. The table and database are using UTF-8 CI-general collation (IIRC)</p>
  
  <p>The urls look something like this:</p>
  
  <p><a href="http://example.com/media/images/47142000/jpg/_47142379_005857853-1.jpg" rel="nofollow noreferrer">http://example.com/media/images/47142000/jpg/_47142379_005857853-1.jpg</a></p>
  
  <p>but they get saved like this:</p>
  
  <p><a href="http://example.com/media/images/47142000/jpg" rel="nofollow noreferrer">http://example.com/media/images/47142000/jpg</a>...</p>
  
  <p>it would seem that the apprearance of the '_' is causing mySQL problems. Do I need to urlencode the string (or perform some other data munging on the string) before saving it to the database?</p>