• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

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

Ralph

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:
You must log in or register to reply here.

Similar threads

S
Issue Error: Connection to the database server failed: SQLSTATE[HY000]: General error: 1273 Unknown collation: 'UTF8_GENERAL_CI'
Replies
5
Views
5K
Peter Debik
P
Giorgio1
Question Wordpress, MariaDB 10.1 and utf8 charset and collation
Replies
3
Views
3K
Giorgio1
Giorgio1
P
MySQL Character Set and Collation
Replies
5
Views
10K
benji
B
P
phpMyAdmin default character set problem
Replies
4
Views
4K
pun119
P
Back
Top