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
Sybase IQ ensures that the original data type of the 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.