January 10, 2020

Understanding UNCOMPRESSED_LENGTH in MySQL

In MySQL, once we use the COMPRESS method to compress a particular text, the LENGTH of the resultant text is not the same as that of the original text. However, using UNCOMPRESSED_LENGTH method on the compressed text results in the exact length of the original text, even though the text