Problem with sqlite blob encoding

[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?

[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

[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.