This content has been marked as final. Show 6 replies
> Is there an easy way to do this if at all?
The whole IDEA of encryption is to make it "difficult" to extract
information out of it without decrypting it.
So - almost by definition - no.
Thanks for your response
Do you know if there's an easy way of determining if data is encrypted once retrieved from the DB?
Like isNumeric(value) but for encrypted data:
Not really. There are stacks of different encryption schemes, and
obviously the encrypted results all look different from scheme to scheme.
How was your data encrypted? I found quite a lot of information regarding Data Encryption Using DBMS_OBFUSCATION_TOOLKIT in Oracle9i Application Developer's Guide - Fundamentals Release 2 (9.2) (Part Number A96590-01) documentation, which can be downloaded from Oracle.
Phil - Data was encrypted using a private key and coldfusion Encrypt(string,key)
FYI - It is indeed possible to search an encrypted column from a CF page. I have built a function to do this and it works very well!
Now I will answer all other similar posts (if you need the answer)