Delphi 12 Athens Updates Available!
To download, click your product: DIContainers, DIConverters, DICreole, DIFileFinder, DIGoogleReader, DIHtmlLabel, DIHtmlParser, DIMime, DIRegEx, DISQLite3, DITidy, DIUcl, DIUnicode, DIXml, YuBrotli, YuImage, YuNetSurf, YuOpenSSL, YuPcre2, YuPdf, YuStemmer, YuXmlSec, YuZip.

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

--- wiki:sqlite3:index [2016/01/22 15:09] – created - external edit 127.0.0.1
+++ wiki:sqlite3:index [2023/01/16 15:29] (current) – Fix broken link. admin
@@ Line 16: / Line 16: @@
 Need to compress database text and BLOBs? You can easily add ZLib compression -- just like MySQL -- to DISQLite3 by registering the custom SQL functions provided in the [[DISQLite3ZLib.pas|DISQLite3ZLib.pas source code unit]]:
-  * **''COMPRESS(text_or_blob_to_compress)''** compresses text or BLOB. The compressed string or BLOB can be uncompressed with ''UNCOMPRESS()''. The argument's type is maintained, which can result in text with #0 characters.((DISQLite3 and [[products:sqlitespy:|SQLiteSpy]] have been well tested to handle in-text #0 characters, but some other SQLite managers are reported to have display problems :-(.)) If the argument can not be compressed, an error is returned. Any other argument type but text or BLOB is returned unchanged. Zero-length arguments are never compressed, the plain zlib compressed output is returned for all others.
+  * **''COMPRESS(text_or_blob_to_compress)''** compresses text or BLOB. The compressed string or BLOB can be uncompressed with ''UNCOMPRESS()''. The argument's type is maintained, which can result in text with #0 characters.(([[..:..:products:sqlite3:|DISQLite3]] and [[..:..:apps:sqlitespy:|SQLiteSpy]] have been well tested to handle in-text #0 characters, but some other SQLite managers are reported to have display problems :-(.)) If the argument can not be compressed, an error is returned. Any other argument type but text or BLOB is returned unchanged. Zero-length arguments are never compressed, the plain zlib compressed output is returned for all others.
   * **''UNCOMPRESS(compressed_text_or_blob)''** uncompresses text or BLOB compresses by the ''COMPRESS()'' function. If the argument is not text or BLOB, it is returned unchanged. If the argument can not be uncompressed, an error is returned. Any other argument type but text or BLOB is returned unchanged.