You really should standardize how the schemas are stored. Differing whitespace should not be significant and stored in this case:
file epiphany/cookies.sqlite midori/cookies.db epiphany/cookies.sqlite: SQLite 3.x database, last written using SQLite version 3019003 midori/cookies.db: SQLite 3.x database, last written using SQLite version 3019003 for i in midori/cookies.db epiphany/cookies.sqlite; do sqlite3 $i .schema; done CREATE TABLE moz_cookies (id INTEGER PRIMARY KEY, name TEXT, value TEXT, host TEXT, path TEXT,expiry INTEGER, lastAccessed INTEGER, isSecure INTEGER, isHttpOnly INTEGER); CREATE TABLE moz_cookies (id INTEGER PRIMARY KEY, name TEXT, value TEXT, host TEXT, path TEXT, expiry INTEGER, lastAccessed INTEGER, isSecure INTEGER, isHttpOnly INTEGER); They differ only by "path TEXT,expiry INTEGER" vs. "path TEXT, expiry INTEGER". This tells me that sqlite3 is storing schemas in some inefficient wrong way! _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users