You need not compress all columns in the table.
create table mail(user_name char(10), mailtxt text compressed = 5, photo image compressed = 1, reply_mail text compressed = 9, attachment image compressed = 100) lock datarows with lob_compression = 0