MariaDB config file and charset

[fossxplorer]

Is is correct that MariaDB 10.x still uses latin1 as charset and the config file is almost empty?
Is that what's default of Kloxo-MR?

Of course i know i how to change them, but just wonder why Kloxo-MR isn't taking care of it.

[MRatWork]

Where you found 'charset' of MariaDB?.

[Spacedust]

Do not apply charset in MariaDB. It will cause problems with all current databases !

[fossxplorer]

MariaDB [(none)]> show variables like "%char%";
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

MariaDB [(none)]> show variables like "%colla%";
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | utf8_general_ci   |
| collation_database   | latin1_swedish_ci |
| collation_server     | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)

As you can see, the server is using latin1 for charset/collation and not UTF8.

@Spacedust, yes, i can't just change now to UTF8 which will create trouble

Where you found 'charset' of MariaDB?.

[MRatWork]

You can run 'sh /script/mysql-convert --utf8=yes' to convert all charset to utf8. It's no problem for mysql but testing for mariadb.