-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/27/2010 11:48 AM, Art Age Software wrote: > New to this list and hoping someone can help. I have a sqlite3 > database that contains a couple of tables that have binary data in > BLOB columns.
Note that there is column affinity, but the data stored for a particular column can differ per row. > I know the data is in there and stored correctly because > the application accessing the database can retrieve the column data > just fine. That doesn't prove it :-) > The problem is that the .dump command produces a dump file with > seemingly truncated BLOB columns. The single most likely cause is that the data is actually stored as text not blobs. The easiest way to check is this: select distinct typeof(columnname) from tablename; When you supply "text" to SQLite APIs (the ones ending in _text) they are expected to be UTF8 encoded bytes. However SQLite does not actually check that it is valid UTF8 encoding. Consequently it is possible to insert random binary data using the text APIs and for it appear to all work correctly. The dump code stops at the first null in any text value but will correctly output a blob value. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkzIlaYACgkQmOOfHg372QSPDQCfcTuAMFa+9vpmBAJ6WMZtCX5M opgAoMKc9THDp58KyaWIl9UvOyVQ/Iac =82WY -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users