COMPRESS()

Overview

Compresses the given string and returns the binary string result.

See also: Functions in 10.6 ES, in 10.5 ES, and in 10.4 ES

EXAMPLES

SELECT HEX(COMPRESS('Now is the time!'));
+----------------------------------------------------------+
| HEX(COMPRESS('Now is the time!'))                        |
+----------------------------------------------------------+
| 10000000789CF3CB2F57C82C5628C9485528C9CC4D5504002FA10582 |
+----------------------------------------------------------+
SELECT LENGTH(COMPRESS('abc'));
+-------------------------+
| LENGTH(COMPRESS('abc')) |
+-------------------------+
|                      15 |
+-------------------------+
SELECT LENGTH(COMPRESS(REPEAT('a',1000)));
+------------------------------------+
| LENGTH(COMPRESS(REPEAT('a',1000))) |
+------------------------------------+
|                                 21 |
+------------------------------------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES