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
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…