Support Article
Optimal length of exposed text encrypted property
SA-44898
Summary
The requirement is to determine the optimal length when exposing a text encrypted property for reporting.
Error Messages
Not Applicable
Steps to Reproduce
Expose the text encrypted property.
Root Cause
Unknown
Resolution
Here’s the explanation for the reported behavior:
The number of bytes allocated for encrypted text must be equivalent to the length of the clear text value. The content of the clear text is also a factor. Generally, for 32-64 byte clear text, 255 characters is sufficient.
If the column size is not large enough to hold the entire encrypted value, it must be truncated similar to an unencrypted value. The truncated encrypted value fails trying to decrypt.Published February 3, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.