February 17, 2017 · Public
Problem and solution – special characters ä, ü, ö or ß
In December 2016 I bought a new desktop computer with Windows 10. I installed the newest version of xampp. After installing my database with phpmyadmin I had a bad error.
My php-program was not able to store the special characters ä, ü, ö or ß Into the database.
I tried to find out the error, but I was not successful – for example I used the utf8_encode function to change the strings into the utf8-format.
With the mysql_connect function I open the connection to the database. When this is successful, I write the following code:
mysql_query("SET NAMES 'utf8'");
After this line of code, everything works correct now.