Data transformation functions

The data transformation functions change data into a different representation for the purposes of security, space savings, or transmission time savings.

The functions in many cases rely on industry-standard algorithms, as noted in the function descriptions. For more information about these algorithms, see the publicly available documentation.

Compressed and encrypted data exists in a binary format that is not readable. To display this data, you must first decompress or decrypt it to avoid output alignment problems. If table columns contain compressed or encrypted data, selects on the table must use the decompress() or decrypt() function to properly process the binary data in those columns.