For non-text data, SQLite 3.x has more efficient storage, as binary data is stored in binary format and not text format. I've heard figures such as 25% savings on disk space bandied about, but YMMV. The storage is not binary compatible with SQLite 2.8.x files, and SQLite 3 cannot read 2.8.x files.
As a data-point, I have a project I'm currently working on, in which all of the db data is either text or numeric (no blobs or other non-text fields), and the difference in size when I convert the 2.8 db to 3.0 format is still close to 25%.
Randy -- [EMAIL PROTECTED] http://www.rjray.org http://www.svsm.org
We will never have true civilization until we have learned to recognize the rights of others.-- Will Rogers
