Encrypt database

You will find several related threads here: Basic4android Search: encrypt database

hi,
I gave it a glance but I have not found anything as I have explained how to encrypt and decrypt database fields in a SQL database.
Thanks if anyone wants to help me
Nicola

You should first encrypt the data with the Encryption library. You should then store the bytes array as a BLOB field. BLOB fields are discussed here: http://www.b4x.com/forum/basic4android-getting-started-tutorials/6736-sql-tutorial.html#post39108

Hi,
return to the question even encrypt or decrypt SQL database, because I can not solve it alone and if someone has the patience to help me out I will be grateful.
I have a sql database "Archivio.db" I have a Customers table with the fields "LastName" ... etc. ...
They can encrypt the entire table or only one field at a time?
If I encrypt a field at a time as I can for:
Encrypt the field "LastName" as I do and how can I save in the table?
How I can decrypt the field "LastName" and use it.
I can perform queries on tables with encrypted fields.
If someone will want to answer with a practical example will be really useful for me.
Sorry for my bad english.
Nicola

Android itself uses the SQLite db engine as part of the OS, but its implementation doesn't support encryption, so you must encrypt yourself manually by encrypting each field, which removes the capability to query the field, or use a standard db and encrypt the entire file, which introduces the possibility that the unencrypted file will somehow be left behind. But as of now, neither Android nor B4A support direct field encryption. Sorry... I'd like to have it too

Thanks You
Thank you very much
So I have to resign, even if it's very limiting.
Nicola
So some programs use a commercial storage system, database owner?

cnicolapc said:

Encrypt the field "LastName" as I do and how can I save in the table?
How I can decrypt the field "LastName" and use it.

Click to expand...

I have attached a small example, that shows a simple way to encrypt and decrypt a single database field with agrahams encryption library.

You need to install encryption library and byteconverter library before you run the example program.

hi,
thank you very much
I will treasure this example.
nicola