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}