Unique Constraint

[edmondsylar]

Is there a way that I can ensure that the data in a filed is unique?
This is in relation to the unencrypted data after fetching it, because since the encrypted values are always different, this kind of disregards the uniqueness of the actual data.

Is there a way around this?

[nite1984]

I think the only way to do this is to create a column with the hashed unencrypted value.
Hashes are always the same for the same input value, so you can use that column to ensure the field is unique.