The following table lists the available compression functions, and a description of their purpose.
Function | Description |
---|---|
CAMSET | Compresses the specified Unicode character data into the following possible values using a proprietary Teradata algorithm:
|
CAMSET_L | Compresses the specified Latin character data into the following possible values using a proprietary Teradata algorithm:
|
DECAMSET | Uncompresses the Unicode data that was compressed using the CAMSET function. |
DECAMSET_L | Uncompresses the Latin data that was compressed using the CAMSET_L function. |
LZCOMP | Compresses the specified Unicode character data using the Lempel-Ziv algorithm. |
LZCOMP_L | Compresses the specified Latin character data using the Lempel-Ziv algorithm. |
LZDECOMP | Uncompresses the Unicode data that was compressed using the LZCOMP function. |
LZDECOMP_L | Uncompresses the Latin data that was compressed using the LZCOMP_L function. |
TD_LZ_COMPRESS | Compresses any supported ALC data type or predefined type data using the Lempel-Ziv algorithm. |
TD_LZ_DECOMPRESS | Uncompresses predefined type data that was compressed using TD_LZ_COMPRESS or UDTs. |
TS_COMPRESS | Compresses TIME and TIMESTAMP with or without time zone to the minimum possible bytes. |
TS_DECOMPRESS | Uncompresses TIME and TIMESTAMP data with or without time zone that the TS_COMPRESS function compressed. |
TransUnicodeToUTF8 | Compress the specified Unicode character data into UTF8 format. |
TransUTF8ToUnicode | Uncompresses the Unicode data that was compressed using the TransUnicodeToUTF8 function. |
See the Teradata Database SQL Functions, Operators, Expressions, and Predicates document, B035-1145, for a detailed overview of these compression functions.