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...

Oops. Just checked and we do not keep the entire track data in the db.
Only a string which hold credit card number/exp/discretionary data portion
of track 2 data such as:


So, as it turns out, that actually IS much smaller data and could be nicely
indexed, no?