Uncompressed character data in Teradata Database requires one byte per character when storing Latin character data. CAMSET_L takes Latin character input, compresses it into partial byte or one byte values, and returns the compressed result.
CAMSET_L provides best results for short or medium Latin strings that:
- contain mainly digits and English alphabet letters.
- do not frequently switch between:
- lowercase and uppercase letters.
- digits and letters.
Although you can call the function directly, CAMSET_L is normally used with algorithmic compression (ALC) to compress table columns. If CAMSET_L is used with ALC, nulls are also compressed if those columns are nullable.