Encrypted DB - Page size
Posted: Wed 22 Aug 2012 13:54
Hi.
I am creating encrypted database with Page Size different then default 1024 .
Two problems happen:
1 Sometimes when viewing database file, I can still see some unencrypted data in it (data that was in column of type TEXT)
2 Sometimes I get an error: "database disk image is malformed" when creating indexes
I tried different encryption algorithms (BlowFish, AES128, AES256, RC4) and page sizes (2048, 4096, 8192).
I am setting Page Size (with "PRAGMA page_size = 4096") on an empty database and then creating tables, adding data and creating indexes.
I am using LiteDac trial.
I am creating encrypted database with Page Size different then default 1024 .
Two problems happen:
1 Sometimes when viewing database file, I can still see some unencrypted data in it (data that was in column of type TEXT)
2 Sometimes I get an error: "database disk image is malformed" when creating indexes
I tried different encryption algorithms (BlowFish, AES128, AES256, RC4) and page sizes (2048, 4096, 8192).
I am setting Page Size (with "PRAGMA page_size = 4096") on an empty database and then creating tables, adding data and creating indexes.
I am using LiteDac trial.