Re: [sqlite] Blob in the callback of sqlite3_exec
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 terminator. But since there's no > length indicator, you'll have trouble with embedded NULs. > > Drop sqlite3_exec, use sqlite3_prepare / sqlite3_step / sqlite3_column_bytes > / sqlite3_column_blob. > -- > Igor Tandetnik > > ___ > sqlite-users mailing list > sqlite-us...@sqlite.orghttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Blob in the callback of sqlite3_exec
Raywrote: > 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 sqlite3_prepare / sqlite3_step / sqlite3_column_bytes / sqlite3_column_blob. -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Blob in the callback of sqlite3_exec
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 mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users