UNCOMPRESSED_LENGTH(compressed_string)

Returns the length that the compressed string had before being compressed. Returns NULL if compressed_string is NULL.

Syntax

MYSQL Copy

SELECT UNCOMPRESSED_LENGTH(COMPRESS(REPEAT('a',30)));
30

Examples

Example

MYSQL Copy

SELECT UNCOMPRESSED_LENGTH(COMPRESS(REPEAT('a',30)));
30