Umlauts/accented letters are not properly shown on a website

Created:

2016-11-16 13:08:47 UTC

Modified:

2017-04-24 11:56:25 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Umlauts/accented letters are not properly shown on a website

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

Umlauts/accented letters are not properly shown on a website.

All the content is stored in MySQL database.

MySQL character set and collation are set to UTF-8.

Website is also using UTF-8.

Cause

MySQL is using another collation during select .

Resolution

  1. Add the following line to my.cnf :

     [mysqld]
    init-connect='SET NAMES utf8'
  2. Restart MySQL service.

Have more questions? Submit a request
Please sign in to leave a comment.