Recovering AES encrypted data from exported SQL
My table has a medium text blob column that I insert AES_encrypted text into.
I have an exported SQL file containing a record I need to recover, but I notice that this method doesn't seem to preserve trailing padding.
Inserting the data back into the blob column and then AES_decrypting it returns a NULL. My thinking is that this is because of the padding.
Is there ANYONE that knows how to recover this data?
What is the padding character used by AES_encrypt? Can I just add that manually to the end of the string of characters I'm inserting back into the blob?
Is there any way to recover the data in this column from a SQL export?
Subject
Views
Written By
Posted
Recovering AES encrypted data from exported SQL
4794
November 21, 2007 08:53AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.