Bug #2951 packing of BLOB/TEXT fields
Submitted: 25 Feb 2004 1:18 Modified: 27 Dec 2006 9:31
Reporter: Pavel Popov Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server: MyISAM storage engine Severity:S4 (Feature request)
Version: OS:
Assigned to: CPU Architecture:Any

[25 Feb 2004 1:18] Pavel Popov
It would be wonderful to realize packing of BLOB/TEXT fields with saving read/write mode.

How to repeat:
[25 Feb 2004 4:46] Heikki Tuuri

InnoDB will probably have an on-the-fly zip compression of data pages around October 2004. That will do the job for BLOBs, too.

But why not to zip-compress BLOBs in the application level?


[8 Dec 2004 5:21] TAT LIM CHIN
Because report designer (like ReportBuilder) put data from sql,
if use application compress function, can not direct uncompress in
report designer.

e.g. compress image files store in database, then
report designer get this image from database.
In this case, we must use database compress/uncompress function.
[27 Dec 2006 9:31] Sveta Smirnova
Thank you for the report.

This feature has implemented already. See: http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html#function_compress  and http://dev.mysql.com/doc/refman/5.1/en/se-falcon-principles-compression.html