Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

MySQL | UNCOMPRESSED_LENGTH( ) Function

  • Last Updated : 17 Feb, 2021

The MySQL UNCOMPRESSED_LENGTH() function is used for returning the length of the string before it had been compressed. It is used on a string that has been compressed using the COMPRESSED() function. 

The MySQL UNCOMPRESSED_LENGTH() function returns NULL if the compressed string is a NULL string. It accepts one parameter which is the compressed string whose length needs to be calculated. 

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

Syntax: 

UNCOMPRESSED_LENGTH(compressed_string);

Parameters Used: 
compressed_string – It is used to specify the compressed string whose length needs to be calculated. 



Return Value: 
The UNCOMPRESSED_LENGTH() function in MySQL returns the length of a compressed string. 

Supported Versions of MySQL: 

  • MySQL 5.7
  • MySQL 5.6
  • MySQL 5.5
  • MySQL 5.1
  • MySQL 5.0
  • MySQL 4.1

Example-1: Implementing UNCOMPRESSED_LENGTH() function on a string. 
 

SELECT  
UNCOMPRESSED_LENGTH(COMPRESS('geeksforgeeks')); 

Output: 

13 

Example-2: Implementing UNCOMPRESSED_LENGTH() function on a string which has a combination of characters and integers. 

SELECT 
UNCOMPRESSED_LENGTH(COMPRESS('geeksforgeeks123')); 

Output: 

16 

Example-3: Implementing UNCOMPRESSED_LENGTH() function on a NULL string and returns the length of the string after compression. 

SELECT
UNCOMPRESSED_LENGTH(COMPRESS(NULL)); 

Output: 

NULL 
My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!