Skip to content

Latest commit

 

History

History
35 lines (27 loc) · 3.67 KB

encryption-and-compression-functions.md

File metadata and controls

35 lines (27 loc) · 3.67 KB
title summary aliases
Encryption and Compression Functions
Learn about the encryption and compression functions.
/docs/dev/functions-and-operators/encryption-and-compression-functions/
/docs/dev/reference/sql/functions-and-operators/encryption-and-compression-functions/

Encryption and Compression Functions

TiDB supports most of the encryption and compression functions available in MySQL 5.7.

Supported functions

Name Description
MD5() Calculate MD5 checksum
PASSWORD() Calculate and return a password string
RANDOM_BYTES() Return a random byte vector
SHA1(), SHA() Calculate an SHA-1 160-bit checksum
SHA2() Calculate an SHA-2 checksum
SM3() Calculate an SM3 checksum (currently MySQL does not support this function)
AES_DECRYPT() Decrypt using AES
AES_ENCRYPT() Encrypt using AES
COMPRESS() Return result as a binary string
UNCOMPRESS() Uncompress a string compressed
UNCOMPRESSED_LENGTH() Return the length of a string before compression
VALIDATE_PASSWORD_STRENGTH() Validate the password strength

Related system variables

The block_encryption_mode variable sets the encryption mode that is used for AES_ENCRYPT() and AES_DECRYPT().

Unsupported functions

  • DES_DECRYPT(), DES_ENCRYPT(), OLD_PASSWORD(), ENCRYPT(): these functions were deprecated in MySQL 5.7 and removed in 8.0.
  • Functions only available in MySQL Enterprise Issue #2632.