SQL Language Guide > SQL Language Guide > Elements of SQL Statements > SQL Functions > Valid and Invalid Passphrase
Was this helpful?
Valid and Invalid Passphrase
A passphrase is similar to a password and is used for authentication purpose. The encryption key is derived from the passphrase and is used to encrypt the protected resource. Listed below are some of the valid and invalid passphrases for the AES_ENCRYPT_IV and AES_DECRYPT_IV functions:
• If the passphrase is set to NULL an error message will be displayed.
• If the value to encrypt or decrypt is set to NULL, the result will be NULL.
• Any string (including an empty string) is a valid passphrase.
Last modified date: 12/19/2024