• 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!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • 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.

Forwarded to devs phpmyadmin wrong charsets

Azurel

Silver Pleskian
User name: Azurel

TITLE

phpmyadmin wrong charsets

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE

centos7.8, centos 8.2, Plesk Obsidian 18.0.29

PROBLEM DESCRIPTION

centos 8.2
  • Server: Localhost via UNIX socket
  • Server type: MariaDB
  • Server version: 10.3.17-MariaDB-log - MariaDB Server
  • Protocol version: 10
  • User: ***@localhost
  • Server charset: cp1252 West European (latin1)
centos 7.8
  • Server: Localhost via UNIX socket
  • Server type: MariaDB
  • Server version: 10.1.45-MariaDB - MariaDB Server
  • Protocol version: 10
  • User: ***@localhost
  • Server charset: cp1252 West European (latin1)
In both Server connection collation is "utf8_unicode_ci".
Its impossible to set it as "utf8mb4_unicode_ci". Its jump every time back to "utf8_unicode_ci".

STEPS TO REPRODUCE

Go to phpmyadmin

ACTUAL RESULT

outdated server charset and connection collation

EXPECTED RESULT

Server charset: UTF-8 Unicode (utf8mb4)
Server connection collation = utf8mb4_unicode_ci

ANY ADDITIONAL INFORMATION

This problem is serious, I can't edit/insert utf8mb4 text with phpmyadmin. I get with this "??" for 4byte characters.

unknown.png


YOUR EXPECTATIONS FROM PLESK SERVICE TEAM

Confirm bug
 
Last edited:
Thank you.
Internal bugreport PPPM-12286 was created.
 
Plesk Obsidian 18.0.35 => Changelog: Updated phpMyAdmin to version 5.1.0.

Unfortunately, the issue is still there.
 
Back
Top