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: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of MBR Sent: Wednesday, March 25, 2009 6:09 PM To: sqlite-users@sqlite.org 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 m...@arlsoft.com <mailto:m...@arlsoft.com> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://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