Re: [sqlite] Blob in the callback of sqlite3_exec

2011-02-08 Thread Ray
Thanks. You remind me those NULs :) On Feb 8, 12:12 am, "Igor Tandetnik" wrote: > Ray wrote: > > What's the actual type of blob in the callback of sqlite3_exec? Is it > > string or remains binary? > > Bytes are reported as-is, with an added zero

Re: [sqlite] Blob in the callback of sqlite3_exec

2011-02-07 Thread Igor Tandetnik
Ray wrote: > What's the actual type of blob in the callback of sqlite3_exec? Is it > string or remains binary? Bytes are reported as-is, with an added zero terminator. But since there's no length indicator, you'll have trouble with embedded NULs. Drop sqlite3_exec, use

[sqlite] Blob in the callback of sqlite3_exec

2011-02-07 Thread Ray
Hi guys, What's the actual type of blob in the callback of sqlite3_exec? Is it string or remains binary? Since when I query the database to get all rows and columns the blob values are not same as what I get from other SQLite tools. ___ sqlite-users