This particular limitation of MySQL hit me HARD HARD HARD circa 2008 when I tried to use some of that upside down text you find online as test data, and just couldn't work out why I was getting data corruption.
Luckily Perl's Unicode support is fantastic, and saved my ass