Page 1 of 1

Problem with sqlite blob encoding

Posted: 23.05.2010, 18:54
by maciejkaczkowski
Based on documentaction http://www.sqlite.org/datatype3.html SQLite allow to insert blob file using hex encoding (x character before string), i.e.:

Code: Select all

INSERT INTO t1 VALUES(x'0500', x'0500', x'0500', x'0500', x'0500');
after executing above example i've got error
unrecognized token: x'0500'

is there any solution to skip parser and send query directly to sqlite engine?

Posted: 26.05.2010, 23:34
by mdaems
What does zeoslib make from your insert statement when sending it to SQLite? You can use a TZSQLMonitor to find that out.
Seems to me the error comes from SQLite itself. because of a syntax error?

Mark

Posted: 29.05.2010, 06:42
by maciejkaczkowski
What does zeoslib make from your insert statement when sending it to SQLite? You can use a TZSQLMonitor to find that out.
not mentioned before that I use TZSQLProcessor to handle instert statement.
Seems to me the error comes from SQLite itself. because of a syntax error?
I've solved that issues using TZQuery - works fine.