Encryption and Compression Functions
TiDB supports most of the encryption and compression functions available in MySQL 5.7.
|Calculate MD5 checksum|
|Calculate and return a password string|
|Return a random byte vector|
|Calculate an SHA-1 160-bit checksum|
|Calculate an SHA-2 checksum|
|Calculate an SM3 checksum (currently MySQL does not support this function)|
|Decrypt using AES|
|Encrypt using AES|
|Return result as a binary string|
|Uncompress a string compressed|
|Return the length of a string before compression|
Related system variables
block_encryption_mode variable sets the encryption mode that is used for
ENCRYPT(): these functions were deprecated in MySQL 5.7 and removed in 8.0.
- Functions only available in MySQL Enterprise Issue #2632.