Creating an Order Column for encrypted data
- by SetiSeeker
I am saving encrypted data to a database.
Is there a way I can create a "hashcode" or fingerprint or checksum of the plain text data, that if I sort / order by on the "hashcode" the order would be the same as if I had saved the plain text data and perform the same sort / order by operation on it?
I basically need a SOUNDEX() type function that…