On Mon, Dec 20, 2010 at 11:59 AM, Dagdamor <[email protected]> wrote:
> 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" > Where did you get this reply from? Are you using some third-party tool? Is it coming from your program, in which case where did your program get it? Is it coming out of the sqlite3.exe command-line shell? The differences are important. Please provide details. A reproducible test case would be nice to have too. > > 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 > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
