Client Identification Types; now supports encrypting Details on the database

Client Identification Types now support encrypting Details on the database. This will encrypt the main Value on the database - not the entire record.

By default, existing Identification Types will not be encrypted. This maintains backwards compatibility, especially important if you are using SQL Queries directly against the database. Once encrypted the ClientId table, Value column will not be readable. Note, new Identification Types will be encrypted by default.

To update encryption, open the Identification Type under the Admin menu and on the General page check "Encrypt Details?".

NOTE: Existing Client Identification records are not automatically updated. You can update all existing records by clicking the "Encrypt Now" button. Newly added or updated Client Identification records will be encrypted.

You can undo encryption by unchecking the Identification Type's "Encrypt Details?", saving, and then clicking "Decrypt Now".

NOTE: Encrypting or Decrypting using the "Encrypt Now" or "Decrypt Now" button is logged as an Activity Log of type "Encrypt Identification Log".

WARNING: There is a limitation on encryption. The encrypted value is often 50% larger than the unencrypted version, e.g. if the unencrypted text is 20 characters, the encrypted version may be 30 characters, The overall size of the database field is 100 characters. If this limit is reached the data is stored unencrypted. This would not normally be an issue as a Driver's Licence or Passport Number is less than 20 characters.