• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Question Change default character-set-server to utf8 - German umlauts?

Ralph

New Pleskian
Hi,

I changed my scripts from PHP 5.6 to 7.2 and from mysql_connect to mysqli_connect. The change to mysqli_connect brings problems saving the German umlauts correctly into a database. The files are UTF8 (no BOM), the database collation is utf8_general_ci.

If I change from the default "character_set_server latin1" to "character_set_server utf8" (via my.cnf and restarting mysql) everything seems fine with saving the German umlauts.

Is this really the correct way?

Does this "character_set_server utf8" effects the Plesk database in a negative way? Will I have trouble after updating Plesk?

Thanks & regards,

Ralph
 
Last edited:
Back
Top