SQLite BLOB Data

Peter Haworth pete at lcsql.com
Fri Feb 6 18:05:20 CET 2015


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>


More information about the use-livecode mailing list