Can't open SQL Cipher database after upgrade SQLiteStudio from 3.2.1 to 3.3.3

[wlodek]

I can't open database (sql sipher) created in SQLiteStudio 3.2.1 using SQLiteStudio 3.3.3. I have now 2 studios 3.2.1 and 3.3.3. Version 3.3.3 can't open (test function also fails) the database. The password is OK - I checked it 100 times.
Any ideas what to do ?

[pawelsalawa]

SQLCipher was updated in SQLiteStudio 3.3, therefore you probably need to enable backward compatibility with your database. You need to do it in the "Cipher configuration" field:

I'm not sure which version you need to put there (1, 2 or 3). The most recent version (and default) is 4. You need to try and test.

Here's official documentation: https://www.zetetic.net/sqlcipher/sqlcipher-api/#cipher_compatibility

If you want to migrate your database to newer version: https://www.zetetic.net/sqlcipher/sqlcipher-api/#cipher_migrate

[wlodek]

Thank You. "PRAGMA cipher_compatibility = 3;" helped.