On 4/4/06, Roman <[EMAIL PROTECTED]> wrote: > Hello, > I am using sqlite3 on am embedded platform. I am using c++ to enter data. I > have BLOB field, and I do not know how to enter hex values from a data > string. I am trying to use update, but how do I enter col_name=' data ' > format? > > How does ' escaping work? I could not find help on the sqlite site, and I am > trying this list.
You don't have to escape the data or dynamically build SQL if you use bind: http://sqlite.org/capi3ref.html#sqlite3_bind_blob
