UNCOMPRESSED_LENGTH()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns the uncompressed length of the given compressed string.
USAGE
UNCOMPRESSED_LENGTH(string)
Argument Name | Description |
|---|---|
| The compressed string to measure |
DETAILS
UNCOMPRESSED_LENGTH() is a string function that returns the uncompressed length of the given compressed string.
A NULL is returned if the argument is NULL or not a compressed string.
EXAMPLES
SELECT UNCOMPRESSED_LENGTH(COMPRESS(REPEAT('abc', 100))) AS result;
+--------+
| result |
+--------+
| 300 |
+--------+