UNCOMPRESSED_LENGTH(compressed_string) returns the length that the compressed string had before being compressed. : UNCOMPRESSED_LENGTH : Encryption Compression Functions MySQL TUTORIALS

Ajax Ajax Examples Ajax Tutorials Scripts and Programs Javascript Javascript Examples Tutorials DHTML Tutorials Javascript References Scripts and Programs HTML HTML Tutorials HTML References HTML DOM 0 References HTML DOM 2 References CSS CSS Tutorials CSS References PHP PHP Source Code PHP References Scripts and Programs C# C# Source Code C# Examples

MySQL TUTORIALS » Encryption Compression Functions » UNCOMPRESSED_LENGTH »   UNCOMPRESSED_LENGTH(compressed_string) returns the length that the compressed string had before being compressed. 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> Leave a Comment / Note Name (required) email (will not be published) (required) Website Vérification Refresh   Enter code Verification is used to prevent unwanted posts (spam). . MySQL TUTORIALS Encryption Compression Functions » UNCOMPRESSED_LENGTH Introduction ENCODE AES_DECRYPT ENCRYPT AES_ENCRYPT MD5 COMPRESS OLD_PASSWORD CRC32 PASSWORD DECODE SHA DES_DECRYPT UNCOMPRESS DES_ENCRYPT UNCOMPRESSED_LENGTH Aggregate Functions Cast Functions Operators Comparison Functions Operators Control Flow Functions Cursor Data Dictionary Data Types Database Date Time Functions Encryption Compression Functions Information Functions Insert Update Delete Introduction Logic Operator Math Numeric Functions Miscellaneous Functions MySQL Utilities Privilege Procedure Function Regular Expressions Select Query String Functions Subquery Table Table Join Trigger View