MySQL tutorial: UNCOMPRESSED_LENGTH [EN]
top of page
CerebroSQL

MySQL: 

UNCOMPRESSED_LENGTH

Syntax:
UNCOMPRESSED_LENGTH(compressed_string)

Returns the length that the compressed string had before being
compressed.

URL: https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html

Example

mysql> SELECT UNCOMPRESSED_LENGTH(COMPRESS(REPEAT('a',30)));
-> 30

bottom of page