Sample Header Ad - 728x90

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