[kmymoney] [Bug 458884] Windows and Linux SQLite databases are not compatible

[Tony Bloomfield]

On 14/08/2023 19:05, Jack via KMyMoney-devel wrote:
> https://bugs.kde.org/show_bug.cgi?id=458884
>
> --- Comment #4 from Jack <ostroffjh at users.sourceforge.net> ---
> Not sure how this got lost, but in your last response, I think you
> misunderstood.  KMM does not bundle sqlite itself, and that is the version I
> was looking for, to see if it doesn't match the linux version.  However, given
> that an unencrypted sqlite database can successfullly be passed between LInux
> and Windows, it is almost certain that the problem is that the two different
> versions of sqlcipher are using different encryption mechanisms, or at least
> different keys.  I recently had a case where saving as an encrypted sqlite
> database on Linux, I could not even open it with sqlcipher from command line.
> I think we will need an sqlite/sqlcipher expert to help solve this.
>
SQLite databases should be compatible. SQLcipher changed encryption 
between versions 3 and 4. See 
https://www.zetetic.net/sqlcipher/sqlcipher-api/

-- 

Cheers
TonyB