SQLite BLOB Data

[Peter Haworth]

When inserting and selecting BLOB data in an SQLite database, Livecode
applies some sort of encoding/decoding thus ensuring that only Livecode
applications can access it.

In LC 6.6, a new revOpenDatabase option, binary, was provided for SQLite
databases which eliminates the encoding. Personally, I think the binary
option should have been the default for new SQLite databases created with
Livecode but that's another story.

Does anyone happen to know the encoding method used for this?

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>