Uses the GZIP algorithm to compress str or bin.
Syntax
binary compress(string <str>)
binary compress(binary <bin>)Parameters
str: required. A value of the STRING type.
bin: required. A value of the BINARY type.
Return value
A value of the BINARY type is returned. If the input parameter is set to null, null is returned.
Examples
Example 1: Use the GZIP algorithm to compress string
hello. Sample statement:-- The return value is =1F=8B=08=00=00=00=00=00=00=03=CBH=CD=C9=C9=07=00=86=A6=106=05=00=00=00. select compress('hello');Example 2: The input parameter is empty. Sample statement:
-- The return value is =1F=8B=08=00=00=00=00=00=00=03=03=00=00=00=00=00=00=00=00=00. select compress('');Example 3: The input parameter is set to null. Sample statement:
-- The return value is null. select compress(null);
Related functions
For more information, see Other functions.