1 of 1

UNCOMPRESSED_LENGTH

Return length of uncompressed string. This function returns the length of a compressed string before it was compressed.

Syntax

UNCOMPRESSED_LENGTH(compressed_string)

Description

Returns the length that the compressed string had before being compressed with .

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.

Examples

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

UNCOMPRESSED_LENGTH

Return length of uncompressed string. This function returns the length of a compressed string before it was compressed.

Syntax

UNCOMPRESSED_LENGTH(compressed_string)

Description

Returns the length that the compressed string had before being compressed with .

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.

Examples

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

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

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

UNCOMPRESSED_LENGTH

hashtagSyntax

hashtagDescription

hashtagExamples

UNCOMPRESSED_LENGTH

hashtagSyntax

hashtagDescription

hashtagExamples

Syntax

Description

Examples

Syntax

Description

Examples