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
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: