Collections:
UNCOMPRESS() - Uncompressing Data
How to uncompress (restore) compressed data using the UNCOMPRESS() function?
✍: FYIcenter.com
UNCOMPRESS(str) is a MySQL built-in function that uncompresses a given compressed byte string using the default LZ77 compression algorithm. For example:
SELECT UNCOMPRESS(x'37000000789C738BF44C4ECD2B492DD24BCECFD57123960700279D13DD'); -- +---------------------------------------------------------------------------+ -- | UNCOMPRESS(x'37000000789C738BF44C4ECD2B492DD24BCECFD57123960700279D13DD') | -- +---------------------------------------------------------------------------+ -- | FYIcenter.com,FYIcenter.com,FYIcenter.com,FYIcenter.com | -- +---------------------------------------------------------------------------+
Reference information of the UNCOMPRESS() function:
UNCOMPRESS(bin): str Uncompresses a given compressed byte string using the default LZ77 compression algorithm. Arguments, return value and availability: bin: Required. The byte string to be uncompressed. str: Return value. The uncompressed byte string. Available since MySQL 4.1.
Related MySQL functions:
⇒ UNCOMPRESSED_LENGTH() - Uncompressed Data Length
⇐ STATEMENT_DIGEST_TEXT() - Calculating Statement Digest
2023-12-14, 244🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...