This table lists the supported datatypes for encrypted columns, as well as the on-disk length of encrypted columns for datatypes.
Datatype |
|
|||||
---|---|---|---|---|---|---|
date |
4 |
varbinary |
17 |
17 |
33 |
33 |
time |
4 |
varbinary |
17 |
17 |
33 |
33 |
smalldatetime |
4 |
varbinary |
17 |
17 |
33 |
33 |
bigdatetime |
8 |
|||||
bigtime |
8 |
|||||
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 |