amavis quarantine table question

[Jernej Porenta via amavis-users]

On 24/02/14 14:51, Deeztek Support via amavis-users wrote:
> The documentation states that in the quarantine table the mail_text
> column should be of data type blob instead of text as it was suggested
> before. However, data type blob cannot be indexed will full text in
> mysql thus queries against the mail_text column take a ridiculous amount
> of time to complete. If I was to change the data type to text, what
> effect if any would this have to the functionality of amavis in general?

What kind of information are you extracting from quarantine table?

IMHO, other tables - msgs, msgrcpt, maddr - provide enough information 
for (at least my) "full" text search queries.

cheers, J.