Syntax
------ 
UNCOMPRESSED_LENGTH(compressed_string)
 
Description
----------- 
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.
 
Until MariaDB 10.3.1, returns MYSQL_TYPE_LONGLONG, or
bigint(10), in all cases. From MariaDB 10.3.1, returns
MYSQL_TYPE_LONG, or int(10), when the result would fit
within 32-bits.
 
Examples
-------- 
SELECT UNCOMPRESSED_LENGTH(COMPRESS(REPEAT('a',30)));
+-----------------------------------------------+
| UNCOMPRESSED_LENGTH(COMPRESS(REPEAT('a',30))) |
+-----------------------------------------------+
| 30 |
+-----------------------------------------------+
 

 
 
 
 
 
 
 

URL: https://mariadb.com/kb/en/uncompressed_length/