Richard Hipp wrote...
On Mon, Feb 11, 2013 at 1:45 PM, jose isaias cabrera
<cabr...@wrc.xerox.com>wrote:
Greetings.
I have this table,
CREATE TABLE Test (login primary key, password);
and I would like to save zlib data using ubyte[] and also call it back
in.
Are you trying to store zlib-compressed content in the database file, then
read back the original uncompressed content? If so, then I suggest adding
two application-defined functions compress() and decompress():
UPDATE test SET password=compress(password) WHERE login='test';
SELECT decompress(password) FROM test WHERE login='test';
Sample implementations for the compress() and decompress() functions can
be
copied from here:
http://www.fossil-scm.org/fossil/artifact/a59638aa4c0?ln=53-105
The code for registering these application-defined functions with the
SQLite database connection is seen here:
http://www.fossil-scm.org/fossil/artifact/a59638aa4c0?ln=119-122
Dr. Hipp, I don't care what Kees or Igor say about you. You're pretty hip.
This is perfect, thanks.
josé
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users