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.