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

[Yafuhenk]

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

 

[Erel]

What is not clear to me when do I have to decrypt and how does that work with the SQL queries?

You will need to get the data as a blob and then decrypt it. The SQL engine will not be able to do anything with the encrypted data except of returning it.