The differences in processing efficiency between MySQL’s three character storage types should not have a big impact on processing times unless your data sets are extremely large.

Looking to use an open source general-purpose database? This extensive comparison of MySQL vs. PostgreSQL explores the strengths and weaknesses of each.