Hi Mark,
There's a good reason for your difficulty -- Sqlite uses dynamic typing:
http://www.sqlite.org/datatype3.html
As far as I know, the term "IndirectBlob" is not defined within sqlite
and is likely a term from the BitPim developers.
Sqlite allows one to use most anything as a type -- "BlobThatAteNewYork"
would work quite nicely.
>From sqlite's point-of-view, if a BLOB contains structure, it's
structure known only to the calling application.
Hope this helps,
Donald
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of MBR
Sent: Wednesday, March 25, 2009 6:09 PM
To: [email protected]
Subject: [sqlite] Documentation on SQLite indirectBLOB?
The Open Source project BitPim uses SQLite. I'm trying to examine the
database BitPim creates. At http://www.sqlite.org/download.html I found
sqlite-3_6_11.zip, which is a pre-compiled Windows command-line SQL
interface.
I ran:
sqlite3 bitpim.db
then typed:
.dump
and saved the output to see what's in the database. The result is a set
of SQL queries that can be used to recreate the database. In the output
I found numerous references to columns of type indirectBLOB. When I
look at the data that gets inserted into those columns, it's pretty
clear that the value in those columns is of the form:
/tableName/,/recordId/,/recordId/,...
But I've been unable to find documentation on the keyword 'indirect' or
'indirectBLOB' anywhere on the web, including
http://www.sqlite.org/docs.html. Can anyone here tell me where to find
that documentation?
Mark Rosenthal
[email protected] <mailto:[email protected]>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
