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

Discussion in 'iOS Questions' started by Yafuhenk, Aug 19, 2019.

  1. Yafuhenk

    Yafuhenk Active Member Licensed 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
     
  2. Erel

    Erel Administrator Staff Member Licensed User

    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.
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice