I am using Qt 6, and I know that a DB file is encrypted with PRAGMA hexkey='123'
, and can be decrypted by QSqlDataBase and then queried in memory.
However, I can't save it as an unencrypted DB file, how can I do that?
I tried QSqlQuery.exec("PRAGMA hexkey='123'")
, and this is querying in memory, but the files are still encrypted.