Aqua Data Studio 15.0.0-dev-63
Build #: 35415
Built on: 2014-Jan-03 09:09:58 AM
Database: SQLite 3
Windows 7: 64 bit
Step 1: Connect to SQLite server.
Step 2: Create a table having column with blob datatype and blob data.
CREATE TABLE "table_test" ( "col1" BLOB )
GO
INSERT INTO "table_test"("col1") VALUES(x'0500')
GO
Step 3: Export data from "table_test" in any file (please refer attached file, 'test_blob.csv' )
Step 4: Right click on table "table_test" -> Select option Tools -> Select Import data.
Import data window opened successfully.
Step 5: Brows to attached file "test_blob.csv" -> Check option "First row contains column names" -> Click Next -> In format tab, in table column info, datatype "blob" is already selected -> click Next -> In option tab, Select destination "preview insert statements" ->Click Next -> Click Next.
Here you will observe that insert statement generated is "INSERT INTO "table_test"("col1") VALUES('0500')" it should be "INSERT INTO "table_test"("col1") VALUES(x'0500')" for blob data.
Morover, if in step 5 we select destination as "import ito database", data imported successfully, but data imported in "text" format.
