>>>>> Roger Binns writes:
>>>>> On 08/16/2011 04:59 PM, Ivan Shmakov wrote:
>> In the sqlite3's .dump command's output, the binary blobs may either
>> be represented as hexadecimal X''-literals, or as text strings.
[…]
> I suggest using typeof on the data you think is blobs to verify what
> type they really are.
The values in question are indeed of mixed type. Thanks!
Yet, it makes me wonder, how the following bit of code could
ever have resulted in a value of the TEXT type being bound?
{
int r
= sqlite3_bind_blob (st, ix_sha1,
sha1, CHUNK_DB_SHA1_LEN,
SQLITE_TRANSIENT);
assert (r == SQLITE_OK);
}
Somehow, I've assumed that sqlite3_bind_blob () will bind a
parameter to a blob.
(It's SQLite 3.7.3 debian 1.)
>> Also, are the .dump and .read commands implemented as part of
>> the sqlite3 binary, or are they part of the library?
> They are part of the standalone shell (ie not the library). The
> shell source code is under the same license as the rest of SQLite (ie
> as public domain as possible) so you are free to make a copy and do
> whatever you want with it.
ACK. Thanks.
--
FSF associate member #7257 Coming soon: Software Freedom Day
http://mail.sf-day.org/lists/listinfo/ planning-ru (ru), sfd-discuss (en)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
