Re: compression

[Apachez]

You could otherwise use COMPRESS() and UNCOMPRESS() in your query.

Such as:

INSERT t1 (col1, col2, col3) VALUES (1, 2, COMPRESS('some text'));

and to read:

SELECT col1, col2, UNCOMPRESS(col3) AS col3_u FROM t1;

For more info http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html