UNCOMPRESSED_LENGTH

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.

Returns MYSQL_TYPE_LONG, or int(10), if the result fits within 32-bits.

Examples

SELECT UNCOMPRESSED_LENGTH(COMPRESS(REPEAT('a',30)));
+-----------------------------------------------+
| UNCOMPRESSED_LENGTH(COMPRESS(REPEAT('a',30))) |
+-----------------------------------------------+
|                                            30 |
+-----------------------------------------------+

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}