As you may know we have SQL functions in both our Real Studio and Filemaker plugins. Getting text encodings right for all cases is a challenge.
So next releases of our plugins have an improved text handling. We use UTF-8/16 everywhere and if the database is also UTF-8 or UTF-16, this should work wonderful and all trouble is gone.
Please if you have a chance, test the new plugin and inform us, if it's working fine for you.
Especially I have to say that MySQLCommunityServer plugin from Real Software seems to return strings without encoding. So there our plugin may be an alternative