Datatypes and encrypted columns

Table 1-21 lists the supported datatypes for encrypted columns, as well as the on-disk length of encrypted columns for datatypes supported for Adaptive Server version 15.0.2.

Table 1-21: Datatype length for 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 length (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

text, image, and unitext datatypes are not supported for this release of Adaptive Server.