Return length of uncompressed string. This function returns the length of a compressed string before it was compressed.
UNCOMPRESSED_LENGTH(compressed_string)Returns the length that the compressed string had before being compressed with COMPRESS().
UNCOMPRESSED_LENGTH() returns NULL or an incorrect result if the string is not compressed.
Returns MYSQL_TYPE_LONG, or , if the result fits within 32-bits.
This page is licensed: GPLv2, originally from
SELECT UNCOMPRESSED_LENGTH(COMPRESS(REPEAT('a',30)));
+-----------------------------------------------+
| UNCOMPRESSED_LENGTH(COMPRESS(REPEAT('a',30))) |
+-----------------------------------------------+
| 30 |
+-----------------------------------------------+