Hexplorer is very handy for this. See also this related question: https://sqlanywhere-forum.sap.com/questions/34024/how-do-i-encrypt-old-rows-after-alter-table-encrypted Hexplorer was quite useful, Breck. Thank you very much. It was also able to verify that the data that predates the... ALTER TABLE <table_name> ENCRYPTED; ...being applied does indeed become encrypted.
(16 Mar '20, 09:04)
appdev
|
To determine whether a database is encrypted, you can fetch If you want to verify that the actual data written to the disk is encrypted, there is no way through SQL or any other interface to retrieve the ciphertext. You'd have to examine the contents of the database file itself. |