mysql>
mysql> SELECT UNCOMPRESS(COMPRESS('any string'));
+------------------------------------+
| UNCOMPRESS(COMPRESS('any string')) |
+------------------------------------+
| any string |
+------------------------------------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT UNCOMPRESS('any string');
+--------------------------+
| UNCOMPRESS('any string') |
+--------------------------+
| NULL |
+--------------------------+
1 row in set, 1 warning (0.00 sec)
mysql>
|