Database Options for Column Encryption

Certain SAP Sybase IQ database option settings affect column encryption and decryption; the default settings are not optimal for most column encryption operations.

• Protect Ciphertext from Accidental Truncation
  To prevent accidental truncation of the ciphertext output of the encrypt function (or accidental truncation of any other character or binary string), set the STRING_RTRUNCATION database option.
• Preserve Ciphertext Integrity
  Set ASE_BINARY_DISPLAY to preserve ciphertext integrity.
• Prevent Misuse of Ciphertext
  Set CONVERSION_MODE to prevent implicit data type conversions of encrypted data that result in semantically meaningless operations.