Supported Data Types

The first parameter of the AES_ENCRYPT function must be one of the supported data types.

CHAR

NUMERIC

VARCHAR

FLOAT

TINYINT

REAL

SMALLINT

DOUBLE

INTEGER

DECIMAL

BIGINT

DATE

BIT

TIME

BINARY

DATETIME

VARBINARY

TIMESTAMP

UNSIGNED INT

SMALLDATETIME

UNSIGNED BIGINT

The LOB data type is not currently supported for SAP Sybase IQ column encryption.