UNCOMPRESSED_LENGTH

Declaration

UNCOMPRESSED_LENGTH(str)

Description

Returns the length of the string before it was compressed by the COMPRESS() function.

Examples

SELECT UNCOMPRESSED_LENGTH(COMPRESS('abc'));
+--------------------------------------+
| UNCOMPRESSED_LENGTH(COMPRESS('abc')) |
+--------------------------------------+
|                                    3 |
+--------------------------------------+
1 row in set (0.001 sec)