title: SQLite database convert string back into blob
body: <p>I have a three SQLite databases, that need to be joined together. I have already tried following procedure:</p>
  
  <p>(1) <code>SELECT column1, column2, quote(column3) from table1 - quote(X) is to convert blob field into string field</code></p>
  
  <p>(2)<code>I import table1.csv back into database, where i define first two fields as INTEGERin third as STRING</code></p>
  
  <p>(3) <code>I use: INSERT INTO table_new (column1, column2, column3) SELECT column1, column2, column3 FROM table1</code></p>
  
  <p>but it doesn't convert correctly (output is a picture.png)</p>
  
  <p>There should be an function that is opposite to QUOTE and would return me back my converted data? </p>
  
  <p>Thank you very much for your help :)</p>