UNCOMPRESS()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Uncompresses and returns the string argument.
USAGE
UNCOMPRESS(string)
Argument Name | Description |
|---|---|
| The binary string to uncompress |
DETAILS
UNCOMPRESS() is a string function that uncompresses and returns the given binary string that was previously compressed using COMPRESS().
A NULL is returned if the argument is NULL or not a compressed string.
EXAMPLES
SELECT UNCOMPRESS(COMPRESS('abcdef'));
+--------------------------------+
| UNCOMPRESS(COMPRESS('abcdef')) |
+--------------------------------+
| abcdef |
+--------------------------------+