title: Attempting to convert SQL Blob to image (From IOS DB, via PHP)
body: <p>I have got a database from my iPhone which contains a massive amount of data.</p>
  
  <p>The Columns are named:</p>
  
  <ul>
  <li>ID</li>
  <li>Thumbnail</li>
  <li>Data</li>
  </ul>
  
  <p>The app it is from is mainly to do with pictures so this leads me to think that the app is storing the pictures into this table.</p>
  
  <p>At closer look, the <code>Thumbnail</code> and <code>Data</code> are Blobs.</p>
  
  <p>I am attempting to convert these Blobs back into a image (but I do not know what content-type they were before).</p>
  
  <p>I have attempted to use <code>base64</code>, <code>file_put_contents</code>, <code>ibase_blob_echo</code> and most of the other ways you can convert a Blob in PHP.</p>
  
  <p>The Blob's signature is: <code>BE 9A BC A4 37 25 78 72 7D (¾š¼¤7%xr})</code></p>
  
  <p>I was hoping to find the signature <a href="http://www.garykessler.net/library/file_sigs.html" rel="nofollow">Here</a> but unfortunately I was unable to find it.</p>
  
  <p>I am not a IOS developer so I don't actually know how or the most common way of converting a image into a blob and retrieving it again; I just assumed that it would be the same as any other application.</p>
  
  <p>If anyone can help me identify this Blob's type or could help me convert convert this Blob in PHP, I would much appreciate it.</p>
  
  <p>(Please note that I do not wish to put the raw Blob data here)</p>
  
  <p>Jamie</p>