Hello guys. I have a problem with inserting BLOB values into a column.
Query: INSERT INTO cachebundles (id,styleid,bundles,plugins,content,compressed) VALUES (NULL,1,'general','',X'7801B58E41',1) SQLite reply: "SQL logic error or missing database" Table schema: CREATE TABLE cachebundles ( id INTEGER PRIMARY KEY, styleid INT NOT NULL, bundles TINYTEXT NOT NULL, plugins TINYTEXT NOT NULL, content LONGBLOB NOT NULL, compressed TINYINT(1) NOT NULL, UNIQUE (styleid,bundles)) Inserting data into regular (non-blob) columns seem to work. What exactly I'm doing wrong? SQLite reply isn't very informative... -- Regards, Serge Igitov _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
