Issue Charset Issue

[Robin McDermott]

Server operating system version

AlmaLinux 9.5

Plesk version and microupdate number

Plesk Obsidian 18.0.67 Update #2

We migrated to a new server in December and have noticed issues with the display of some characters in our web application:

Dvorský



Years ago when we had this issue, we added:

AddDefaultCharset ISO-8859-1

in Additional Apache directives to HTTP and HTTPS for each affected domain to overcome a similar problem with "special" characters (to us in North America).

I am wondering if we should be using a different charset? We do translate content into several different languages (Chinese, Japanese, Russian, Polish...) and don't want that to be impacted by any changes.

 

[Raul A.]

What PHP version are you using? We encountered such an issue when using an old MySQL connector from PHP 5.x.

 

[Robin McDermott]

What PHP version are you using? We encountered such an issue when using an old MySQL connector from PHP 5.x.

We are using Plesk 8.3.19.

 

[Raul A.]

Do your connection collation and charset match the database collation and charset?

MariaDB [(none)]> SHOW SESSION VARIABLES LIKE 'character\_set\_%';
+--------------------------+---------+
| Variable_name            | Value   |
+--------------------------+---------+
| character_set_client     | utf8mb3 |
| character_set_connection | utf8mb3 |
| character_set_database   | latin1  |
| character_set_filesystem | binary  |
| character_set_results    | utf8mb3 |
| character_set_server     | latin1  |
| character_set_system     | utf8mb3 |
+--------------------------+---------+
7 rows in set (0.001 sec)

MariaDB [(none)]> SHOW SESSION VARIABLES LIKE 'collation\_%';
+----------------------+--------------------+
| Variable_name        | Value              |
+----------------------+--------------------+
| collation_connection | utf8mb3_general_ci |
| collation_database   | latin1_swedish_ci  |
| collation_server     | latin1_swedish_ci  |
+----------------------+--------------------+
3 rows in set (0.001 sec)

 

[Robin McDermott]

We are not using this with a database application so are these questions related to MariaDB relevant?

 

[Raul A.]

Sorry about that. I was under the impression you were getting the data from a database. In this case, the MariaDB part is not relevant.

 

[Robin McDermott]

Sorry about that. I was under the impression you were getting the data from a database. In this case, the MariaDB part is not relevant.

Not a problem...I appreciate your thoughts.