Datatypes and encrypted columns

This table lists the supported datatypes for encrypted columns, as well as the on-disk length of encrypted columns for datatypes.

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