w3resource

MySQL UNCOMPRESSED_LENGTH() function

UNCOMPRESSED_LENGTH() function

MySQL UNCOMPRESSED_LENGTH() returns the length of the string before it had been compressed.

Syntax:

UNCOMPRESSED_LENGTH(string)

Argument

Name Description
str A compressed string.

Syntax Diagram:

MySQL UNCOMPRESSED_LENGTH() Function - Syntax Diagram

MySQL Version: 5.6


Example

Code:

SELECT UNCOMPRESSED_LENGTH(COMPRESS('w3resource'));

Explanation

The above MySQL statement returns 10, which is the length of the original string w3resource.

Sample Output:

mysql> SELECT UNCOMPRESSED_LENGTH(COMPRESS('w3resource'));
+---------------------------------------------+
| UNCOMPRESSED_LENGTH(COMPRESS('w3resource')) |
+---------------------------------------------+
|                                          10 | 
+---------------------------------------------+
1 row in set (0.00 sec)

Previous: UNCOMPRESS()
Next: MySQL Bit functions BIT_COUNT



Inviting useful, relevant, well-written and unique guest posts