Neither build SQLCipher myself nor install by command ‘brew install SQLCipher’ can decrypt the encrypted database from Android ,it always show tips 'file is not database '.In android device ,the db can use without problem , but when i export it to my Mac and try to decrypt ,it not works.
On my Mac ,I can create encrypted database and decrypt it success .
Mac SqlCipher version: SQLite version: 3.33.0 2020-08-14 13:23:32 (SQLCipher 4.4.2 community)
Android SqlCipher version: ‘net.zetetic:android-database-sqlcipher:3.5.6’
There are two options:
- You can upgrade SQLCipher android to the latest 4.5.0, which will be compatible by default with SQLCipher 4 used on macOS
2.UsePRAGMA cipher_compatibility=3
on macOS to create or open a database that is compatible with SQLCipher 3 on android.
I’ve try the second option, it works, thanks.