|Problems? Is your data what you think it is?|
Need tipps for identifying utf-8 problems with Dancer and MySQLby Skeeve (Vicar)
|on May 05, 2014 at 10:52 UTC||Need Help??|
Skeeve has asked for the
wisdom of the Perl Monks concerning the following question:
I have a MySQL table containing some string using german Umlauts. As far as I can see from MySQL these strings are stored in UTF-8 and using MySQL workbench they appear correct.
Now I have a Dancer application which is retrieving those strings. config.yml defines the charset to be UTF-8 and in fact returning static strings containing umlauts, either from my templates or from a perl string seems fine.
Just the strings I retrieve from the database get messed upped. Instead of "ü" I get for example "Ã¼".
I hope some of you have some good tipps to identify the source of my problem.