Subject RE: [firebird-support] Querying Encrypted fields?
Author Lee Jenkins
> Hello,
> Is the encrypted number stored as ASCII? If so, you could just index the
> encrypted CC number. When you want to query against it, encrypt the CC
> number in the client and pass the encrypted result as a parameter to the
> procedure (or query).
> Perhaps I am missing something, but this seems like it should work.
> Kevin Lingofelter

Yes, recently I switched to using the TP crypt stuff for the plain text
encryption it offers. The only thing is that we store ALL track 2 and 3
data from the credit card which is usually about 100 bytes long so I wasn't
sure about the feasibility of using an index on a field that long...