​
decrypt

decrypted binary string (return) Supported Signatures

function decrypt(binary, varchar) returns binary
function decrypt(binary, varchar, binary) returns binary
function decrypt(binary, varchar, binary, varchar) returns binary
function decrypt(binary, varchar, varchar) returns binary
function decrypt(binary, varchar, varchar, varchar) returns binary

🔗 Official Documentation

​
decrypt_raw

decrypted binary string (return) Supported Signatures

function decrypt_raw(binary, binary) returns binary
function decrypt_raw(binary, binary, binary) returns binary
function decrypt_raw(binary, binary, binary, binary) returns binary
function decrypt_raw(binary, binary, binary, binary, varchar) returns binary
function decrypt_raw(binary, binary, binary, binary, varchar, binary) returns binary

🔗 Official Documentation

​
encrypt

encrypted binary string including IV/nonce and AEAD tag (return) Supported Signatures

function encrypt(binary, varchar) returns binary
function encrypt(binary, varchar, binary) returns binary
function encrypt(binary, varchar, binary, varchar) returns binary
function encrypt(varchar, varchar) returns binary
function encrypt(varchar, varchar, binary) returns binary
function encrypt(varchar, varchar, binary, varchar) returns binary
function encrypt(binary, varchar, varchar) returns binary
function encrypt(binary, varchar, varchar, varchar) returns binary
function encrypt(varchar, varchar, varchar) returns binary
function encrypt(varchar, varchar, varchar, varchar) returns binary

🔗 Official Documentation

​
encrypt_raw

variant containing the encrypted binary string and additional data (return) Supported Signatures

function encrypt_raw(binary, binary) returns variant
function encrypt_raw(binary, binary, binary) returns variant
function encrypt_raw(binary, binary, binary, binary) returns variant
function encrypt_raw(binary, binary, binary, binary, varchar) returns variant

🔗 Official Documentation

​
try_decrypt

decrypted binary string (return) Supported Signatures

function try_decrypt(binary, varchar) returns binary
function try_decrypt(binary, varchar, binary) returns binary
function try_decrypt(binary, varchar, binary, varchar) returns binary
function try_decrypt(binary, varchar, varchar) returns binary
function try_decrypt(binary, varchar, varchar, varchar) returns binary

🔗 Official Documentation

​
try_decrypt_raw

decrypted binary string (return) Supported Signatures

function try_decrypt_raw(binary, binary) returns binary
function try_decrypt_raw(binary, binary, binary) returns binary
function try_decrypt_raw(binary, binary, binary, binary) returns binary
function try_decrypt_raw(binary, binary, binary, binary, varchar) returns binary
function try_decrypt_raw(binary, binary, binary, binary, varchar, binary) returns binary

🔗 Official Documentation

Date & Time FunctionsGeospatial Functions