At my previous^2 company we worked around MySQL's limitations by just storing our data in VARBINARY columns, encoded as utf8 on the client-side. Worked like a charm. (I hate MySQL)