Does anyone know how I can easily search an encrypted column?
I have a whole bunch of sensitive material (text/html) stored
as encrypted data but I can't see any easy way of searching that
data for a keyword without openeing every record, decrypting the
column, then searching it before moving on to the next record.
Is there an easy way to do this if at all?
Hi Adam
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:
e.g. isEncrypted(value)
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.
Adam
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)