Doctrine encoding error

Asked Feb 03 '17 at 15:35

Active Feb 03 '17 at 15:35

Viewed 61 times

In development I am using a MySQL database on windows with a schema where I set the charset to UTF-8 and the collation to default collation. As O/R-Mapper I am using Doctrine 2. When I am on my windows machine there is no encoding problem of any sort, but as I deployed the code / database to a productive server which runs on linux, an encoding problem popped up: When I take a look at the data inside the tables using MySQL-Workbench, it looks like this

On the other side, the application just works fine, as there is no encoding problem, but as I update the data using the MySQL-Workbench with some special characters (äöü ...), an encoding problem is then visible on the website.

asked Feb 03 '17 at 15:35

0xDECAFBAD

What encoding do you have on your files? Are they also in `utf-8`? – M. Eriksson Feb 03 '17 at 15:42
If you mean PHP/HTML-Files then UTF-8. – 0xDECAFBAD Feb 03 '17 at 15:43
I mean all the files.. including the PHP files that fetches things from the database. – M. Eriksson Feb 03 '17 at 15:43
the files are UTF-8 encoded – 0xDECAFBAD Feb 03 '17 at 15:48
Look for "Mojibake" in http://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored – Rick James Feb 04 '17 at 02:07

MySQL / PHP / Doctrine encoding error

0 Answers0