-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 jose isaias cabrera wrote: > Can SQLite3 save binary data?
http://sqlite.org/datatype3.html Look for blobs. > I would like to save zip files on it. Is > this possible? Yes. There is a limit of 2GB per item and there is no random access api to retrieve part of a blob - you have to get the whole thing in one go. In general better practise is to store the zip files in the filesystem and store the name of the file in SQLite. > If so, is there a place where I can read or get some > examples about it? Blobs are just another SQLite datatype so you manipulate them in exactly the same way as you do other types. http://sqlite.org/docs.html The topic also comes up fairly frequently on this list. You can examine the list archives for previous discussion. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFF2Uj0mOOfHg372QQRAhPJAKDY/M/aash7JD7xlOGp0m/xwwHbjgCeJXj9 kiUUCu+a/POfb1PzP4Nf3Yw= =Tb74 -----END PGP SIGNATURE----- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
