I’m starting to play with 4.0.0 on Windows.
I have successfully built sqlcipher.dll and a sqlcipher.exe.
All seem to function for creating a database and encrypting it with
PRAGMA key = ‘password’;
Its seems it is critical that this is the first command after opening the database.
If I try to do a SELECT and then the PRAGMA, the PRAGMA will fail.
Is this correct?
Now - how do I create a un-encrypted database using sqlcipher.exe?
It seems that the following does not produce and error but is also ignored
PRAGMA rekey; or
PRAMGA rekye = ‘’;