Mode Recommendations
CTP UDFs are available in different general data mode categories:
encrypt_cbc,encrypt_fpe,encrypt_ff1encrypt_charencrypt_string
Following UDFs support a Latin character set:
encrypt_char/decrypt_charencrypt_string/decrypt_data
Note
encrypt_char takes an extra argument (column size) and it encrypts until the given column size, including any spaces present at the end of data in a column.
Usually, Teradata truncates spaces present at the end of input data, but CTP is designed to encrypt spaces present after the input data.
It is not recommend to use encrypt_char/decrypt_char UDFs unless explicitly required.
Following are Unicode-supported UDFs (that is, they support both Unicode and Latin character sets):
encrypt_cbc/decrypt_cbcencrypt_fpe/decrypt_fpeencrypt_ff1/decrypt_ff1
The fpe and ff1 UDFs are well-suited to preserve data format after encryption/decryption. In general, it is recommend to use Unicode-supported UDFs instead of Latin ones.
Note
VPTD supports Unicode characters up to 0xFFFF (that is, up to codepoint 65535). The character set range is specified in the profiles.conf file. When the character set range is beyond 65535 (0xFFFF), an error message will occur during FPE UDF call.
