iOS Question Encrypt field in table and store as blob..and then?

Yafuhenk

Active Member
Licensed User
Longtime User
Hi,
I like to use sqlcipher for B4i but I learnt that that is not possible for the moment.
In this link https://www.b4x.com/android/forum/threads/sqlcipher-or-something-like-this.48378/ it is suggested to encrypt a field and then store it as BLOB.
In this link https://www.b4x.com/android/forum/threads/read-and-write-blob-text-field-sqlite.55769/#content I find more information how to store (encrypted text) as BLOB and how to read it again.
What is not clear to me when do I have to decrypt and how does that work with the SQL queries?
Thanks for your suggestions
 
Top