I'm trying to force clients to use utf8mb4_unicode_520_ci and uft8mb4.
I tried to add this to all my galera cluster nodes
[mysqld]
...
collation-server = utf8mb4_unicode_520_ci
init-connect='SET NAMES utf8mb4'
character-set-server = utf8mb4
character-set-client-handshake = FALSE
skip-character-set-client-handshake = 1
...
However when I connect with HeidiSQL or mysql-connector-python it never uses it and even says collation-database: latin1_swedish_ci
Using Mariadb 10.11.7 with galera cluster and checking with SHOW VARIABLES LIKE '%collation%';
Altered my db with
ALTER TABLE XXXX CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
I want to forbid any client to use different values than the server
