Yafuhenk Active Member Licensed User Longtime User Aug 19, 2019 #1 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
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 B4X founder Staff member Licensed User Longtime User Aug 19, 2019 #2 YAFUHENK said: What is not clear to me when do I have to decrypt and how does that work with the SQL queries? Click to expand... 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. Upvote 0
YAFUHENK said: What is not clear to me when do I have to decrypt and how does that work with the SQL queries? Click to expand... 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.