Re: [sqlite] Blob in the callback of sqlite3_exec

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

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