• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    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. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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
4K
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