MySQL Tutorial/Encryption Compression Functions/UNCOMPRESSED LENGTH
Версия от 16:44, 26 мая 2010; (обсуждение)
UNCOMPRESSED_LENGTH(compressed_string) returns the length that the compressed string had before being compressed.
<source lang="sql">
mysql> mysql> mysql> SELECT UNCOMPRESSED_LENGTH(COMPRESS(REPEAT("a",30))); +-----------------------------------------------+ | UNCOMPRESSED_LENGTH(COMPRESS(REPEAT("a",30))) | +-----------------------------------------------+ | 30 | +-----------------------------------------------+ 1 row in set (0.00 sec) mysql> mysql></source>