Data Types for Encrypted Columns

The data types supported for encrypted columns and working with these data types.

• Supported Data Types
  The first parameter of the AES_ENCRYPT function must be one of the supported data types.
• Preservation of Data Types
  SAP Sybase IQ ensures that the original data type of plaintext is preserved when decrypting data, if the AES_DECRYPT function is given the data type as a parameter, or is within a CAST function.
• Effect of Different Data Types on Ciphertext
  To produce identical ciphertext for different datatypes, cast the input of AES_ENCRYPT to the same data type to produce identical ciphertext.