Richard Hipp <[email protected]> писал(а) в своём письме Mon, 20 Dec 2010 23:13:33 +0600:
> 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. I'm working with PHP (version 5.2.6) and using its standard SQLite extension (sqlite_xxx functions). I've simplified my situation a bit: CREATE TABLE test1 (content BLOB) INSERT INTO test1 (content) VALUES ('test') Works okay, but CREATE TABLE test2 (content BLOB) INSERT INTO test2 (content) VALUES (X'1234') "SQL logic error or missing database" > :/ Here is an extract from phpinfo(): PHP Version 5.2.6 SQLite support enabled PECL Module version 2.0-dev $Id: sqlite.c,v 1.166.2.13.2.10 2007/12/31 07:20:11 sebastian Exp $ SQLite Library 2.8.17 SQLite Encoding iso8859 Hope that's useful enough... if not, I'll send a test case to reproduce. So far I'm thinking that I've messed with SQL syntax somewhere, but cannot guess where exactly. Thanks in advance. -- Regards, Serge Igitov _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
