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.