sql - SQLite database convert string back into blob -

i have 3 sqlite databases, need joined together. have tried following procedure:

(1) select column1, column2, quote(column3) table1 - quote(x) convert blob field string field

(2)i import table1.csv database, define first 2 fields integerin third string

(3) i use: insert table_new (column1, column2, column3) select column1, column2, column3 table1

but doesn't convert correctly (output picture.png)

there should function opposite quote , return me converted data?

thank :)

there no built-in sql function converts blob literal (x'102234') blob, because such literal intended used in sql commands.

the easiest way move data between databases use sqlite3 command-line tool:

sqlite3 old.db ".dump" > data.sql sqlite3 new.db < data.sql 

other tools sqlite manager have similar functions export/import databases.