HI,
We are doing a fresh install of OJS3 on a new platform. Our MariaDB will be on a Galera Cluster. After setting up the DB and verified it specs we have found that character_set_server & collation_server are still in latin1
. It seems that we cannot change these defaults values because they are inherited from the Galeria platform that was compiled in latin1
. This is what we have:
MariaDB []> show variables like "%collation%";
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | latin1_swedish_ci |
+----------------------+-------------------+
MariaDB []> show variables like "character_set%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
We will use a multilingual instance (fr_CA; en_US; es_ES). We are wandering if there could be any problems in OJS3 with letting these two variables in latin1
. Maybe some problems in the DB or when exporting-importing users or dumpfile? Would the OAI-PMH be affected ? In some forms (text-entering) for the users or in the sending of emails?
Any thoughts on this ?
Thanks,
Pierre