mysql data compression

I have some data in a few columns that repeat of开发者_Python百科ten from 40-80%.

Is there some way to have mysql do some kind of compression?

Gordon

Repeating data? Sounds like you're breaking normalization rules. I'd investigate those before resorting to compression. How do you intend to query on compressed data? Not useful, in my opinion.