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
2024-12-18, 458🔥, 0💬
Popular Posts:
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...