• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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