Datatypes and Encrypted Columns

Some SAP ASE datatypes support encrypted columns, as well as the on-disk length of encrypted columns.

Datatype	Input Data Length	Encrypted Column Type	Max Encrypted Data Length (No init_vector)	Actual Encrypted Data Length (No init_vector)	Max Encrypted Data Length (With init_vector)	Actual Encrypted Data Kength (With init_vector)
`date`	4	`varbinary`	17	17	33	33
`time`	4	`varbinary`	17	17	33	33
`smalldatetime`	4	`varbinary`	17	17	33	33
`bigdatetime`	8	`varbinary`	17	17	33	33
`bigtime`	8	`varbinary`	17	17	33	33
`datetime`	8	`varbinary`	17	17	33	33
`smallmoney`	4	`varbinary`	17	17	33	33
`money`	8	`varbinary`	17	17	33	33
`bit`	8	`varbinary`	17	17	33	33
`bigint`	8	`varbinary`	17	1 7	33	33
`unsigned bigint`	8	`varbinary`	17	17	33	33
`unichar(10)`	2 (1 `unichar` character)	`varbinary`	33	17	49	33
`unichar(10)`	20 (10 `unichar` characters)	`varbinary`	33	33	49	49
`univarchar(20)`	20 (10 `unichar` characters)	`varbinary`	49	33	65	49

The text, image, and unitext datatypes do not support encrypted columns.