Mariadb can't enforce charset and collation to clients
0
votes
0
answers
174
views
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
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
Asked by Freedo
(208 rep)
May 3, 2024, 08:10 AM
Last activity: May 3, 2024, 02:38 PM
Last activity: May 3, 2024, 02:38 PM