majic-ansible-roles Files · roles/database_server/templates/utf8.cnf.j2

Files @ 2e3f14bc1505

Branch filter:

Location: majic-ansible-roles/roles/database_server/templates/utf8.cnf.j2

2e3f14bc1505 462 B text/plain Show Annotation Show as Raw Download as Raw

branko

MAR-192: Added support for Debian 12 Bookworm to database_server role:

- Newer versions of MariaDB are planning on making the utf8 become a
default alias for utf8mb4. Stick to utf8mb3 currently for
compatibility purposes.

{% if ansible_distribution_release == 'bullseye' %}
[client]
default-character-set = utf8

[mysqld]
character-set-server  = utf8
collation-server      = utf8_general_ci
character_set_server  = utf8
collation_server      = utf8_general_ci
{% else %}
[client]
default-character-set = utf8mb3

[mysqld]
character-set-server  = utf8mb3
collation-server      = utf8mb3_general_ci
character_set_server  = utf8mb3
collation_server      = utf8mb3_general_ci
{% endif %}