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, 225🔥, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...