Hi,
I have a table "Employees" and along with other columns, there is a string column "Referred By" and requirement is to keep this column's data as encrypted or encoded or manage in some way so even Postgresql DBA can't see the column's data on the Postgresql server.
From UI perspective, the requirement on this field is as the user will type characters in the 'Referred By' text box on UI form, a like operator search with entered characters will be performed just like Firefox's quick search functionality, e.g. if 'Andr' is entered then all records with Andr% needs to be fetched and shown. Just to remind, this column's data needs to be either encrypted or encoded or some way of DB plus NHibernate security to prevent the contents of this column to be seen from Postgresql DBA.

Initially I thought of encrypting this column, but then the UI requirement cannot be met or am I wrong in this regard?

How can this situation be managed in NHibernate? I welcome all options with open mind!