Collections:
UNCOMPRESSED_LENGTH() - Uncompressed Data Length
How to calculate the original data length of a compressed byte string using the UNCOMPRESSED_LENGTH() function?
✍: FYIcenter.com
UNCOMPRESSED_LENGTH(str) is a MySQL built-in function that returns the original data length of a given compressed byte string. For example:
SET @bin = x'37000000789C738BF44C4ECD2B492DD24BCECFD57123960700279D13DD'; SELECT LENGTH(@bin), UNCOMPRESSED_LENGTH(@bin); -- +--------------+---------------------------+ -- | LENGTH(@bin) | UNCOMPRESSED_LENGTH(@bin) | -- +--------------+---------------------------+ -- | 29 | 55 | -- +--------------+---------------------------+
Reference information of the UNCOMPRESSED_LENGTH() function:
UNCOMPRESSED_LENGTH(bin): len Returns the original data length of a given compressed byte string. Arguments, return value and availability: bin: Required. The compressed byte string to be examined. len: Return value. The number of bytes of the original byte string. Available since MySQL 4.1.
Related MySQL functions:
⇒ VALIDATE_PASSWORD_STRENGTH() - Password Strength Test
⇐ UNCOMPRESS() - Uncompressing Data
2023-12-14, 220🔥, 0💬
Popular Posts:
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...