• Inviting everyone who uses WordPress management tools in Plesk
    The Plesk team is conducting a 60-minute research session that includes an interview and a moderated usability test.
    To participate, please use this link .
    Your experience will help shape product decisions and ensure the tools better support real-world use cases.

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