Mysql UNCOMPRESSED LENGTH
From w3cyberlearnings
Contents |
MySQL UNCOMPRESSED_LENGTH Function
This function returns the length of the string before being compressed.
Syntax UNCOMPRESSED_LENGTH
- str: compressed string
UNCOMPRESSED_LENGTH(str);
Example 1
mysql> SELECT UNCOMPRESSED_LENGTH(COMPRESS('aaa 4'));
+----------------------------------------+
| UNCOMPRESSED_LENGTH(COMPRESS('aaa 4')) |
+----------------------------------------+
| 5 |
+----------------------------------------+
1 row in set (0.00 sec)
mysql> SELECT UNCOMPRESSED_LENGTH(COMPRESS('aaa'));
+--------------------------------------+
| UNCOMPRESSED_LENGTH(COMPRESS('aaa')) |
+--------------------------------------+
| 3 |
+--------------------------------------+
1 row in set (0.00 sec)
Related Links
- SHA
- SHA2
- UNCOMPRESS
- UNCOMPRESSED_LENGTH
