• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

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