Default collation of the mariadb schemas is latin1 instead of utf8

Hello,

Please change the default collation of the mariadb from latin1 to utf8.

In Freepbx13 the default collation is correct (utf8).

Here is the output from my latest 14 version:

MariaDB [asteriskcdrdb]> select default_character_set_name from information_schema.schemata where schema_name = "asteriskcdrdb";
+----------------------------+
| default_character_set_name |
+----------------------------+
| latin1                     |
+----------------------------+
1 row in set (0.00 sec)MariaDB [asteriskcdrdb]> select default_character_set_name from information_schema.schemata where schema_name = "asterisk";     
+----------------------------+
| default_character_set_name |
+----------------------------+
| latin1                     |
+----------------------------+
1 row in set (0.00 sec)

And here is the output from the latest 13 version:

mysql> select default_character_set_name from information_schema.schemata where schema_name = "asteriskcdrdb";
+----------------------------+
| default_character_set_name |
+----------------------------+
| utf8                       |
+----------------------------+
1 row in set (0.00 sec)mysql> select default_character_set_name from information_schema.schemata where schema_name = "asterisk";     
+----------------------------+
| default_character_set_name |
+----------------------------+
| utf8                       |
+----------------------------+
1 row in set (0.00 sec)

Thank you,

Daniel Friedman

Trixton LTD.