How to calculate the original data length of a compressed byte string using the UNCOMPRESSED_LENGTH() function?

UNCOMPRESSED_LENGTH(str) is a MySQL built-in function that returns the original data length of a given compressed byte string. For example:

SET @bin = x'37000000789C738BF44C4ECD2B492DD24BCECFD57123960700279D13DD';

SELECT LENGTH(@bin), UNCOMPRESSED_LENGTH(@bin);
  -- +--------------+---------------------------+
  -- | LENGTH(@bin) | UNCOMPRESSED_LENGTH(@bin) |
  -- +--------------+---------------------------+
  -- |           29 |                        55 |
  -- +--------------+---------------------------+

Reference information of the UNCOMPRESSED_LENGTH() function:

UNCOMPRESSED_LENGTH(bin): len
  Returns the original data length of a given compressed byte string.

Arguments, return value and availability:
  bin: Required. The compressed byte string to be examined.
  len: Return value. The number of bytes of the original byte string.
  Available since MySQL 4.1.

Related MySQL functions:

• COMPRESS() - Compressing Data
• UNCOMPRESS() - Uncompressing Data
• UNCOMPRESSED_LENGTH() - Uncompressed Data Length

⇒ VALIDATE_PASSWORD_STRENGTH() - Password Strength Test

⇐ UNCOMPRESS() - Uncompressing Data

⇑ MySQL Functions for Encryption and Compression

⇑⇑ MySQL Function References